how to store static data that will be localized?

Question

I am developing a health care system and I want the doctor when starting to type a diagnosis instead of typing it , he can select from a list that will be displayed for him.

the list contains diseases or symptoms that will then be inserted into database in a diagnosis table.

I did that because of two reasons:

• I want all doctors to use the same list of symptoms when writing their diagnosis to work on that data later on, instead of each one typing his own way.

• The data will be localized and translated to different languages when displayed to different regions.

I am facing a problem here, should i put all these in a lookup table in a database or a config file ? given that number of rows are 3000 in 7 languages ( each language will have it's own column ) and i may at anytime add new data or remove.

Answer 1

I would put them in a database. I find it easier to maintain, and faster to query than a config file.