struct vs. database: efficiency?

[ingernet]

Hi all,

I have an application that I'll need to roll out to anywhere from 3000 to 20,000 users in a variety of languages.

It's a 10-step survey application that will ask the same questions and have the same input buttons in 6 different languages. Pages are labelled step6, step7, etc.

So my question is: which is more efficient:
a. to create a small table for each step, e.g.:

STEP6
QNum    Q_En    Q_Es    Q_De    Q_Jp    Q_Fr

Or to use a struct?

I don't know enough at this point about server memory and resources to make an informed call on this.

Thanks!

Inger

 

[ingernet]

In case anyone was wondering, I decided to scrap both ideas. I think the safest way to go about doing this is to use a CFSWITCH construct to look for language, then set page-specific variables for each language. (e.g. radio1_1, radio1_2.) Ihave nightmares about databases melting down and 20-checkbox pages yielding 120 struct elements, all of which are called at the same time by 3000 people. yikes!

inger

 

[TamedTech]

Just a word of warning;

Contradictory to popular belief, <cfif> with <cfelseif> is much more efficient than <cfswitch>.

Rob