Hello all;

I am developing an app that must display everything in one of three languages (English, French, Spanish). I would like input on the best way to do this. The options being considered at present are:

1. Store all info in an Oracle table, and each time a form loads, pull the approriate captions and populate the form.

2. Store the info in Oracle, and load all captions when app starts up into an array - then as each form loads, pull the values from the array. The array would have to store values of a user defined type that would include the name of the form and either the index for the control (if it is in control array - most of which are) or the actual name of the control, as well as its caption.

3. Use a ressource file


I have already explored option 1, and it seems to work OK, but there is a DB concern as this app will run on a central server that users will access via terminal services - there could be as many as 100 users at one time using the app. Option 2 should work but I am concerned about excessive RAM consumption (array would have to be about 700 elements). Option 3 is the latest one to be considered - although it is new to me and I am still learning about .res files. With 3 languages at 700 captions or so each, that would put the number of string entries in the .res file at about 2100 - is this too much maybe?


Any thoughts would be much obliged.