AnsweredAssumed Answered

Fields, Repeating Fields, Calculations? Which are best for performance?

Question asked by jobemay on Feb 26, 2012
Latest reply on Feb 27, 2012 by jobemay

Hello,

I'm working on a big database (special verb dictionary). Which variant will provide best performance? Is there a big difference at all?

 

Example: Want to show "arbeiten arbeite arbeitest" in a layout. (German for: "(to) work (I) work (you) work"). Database with about 10000 records

 

  1. a single textfield for each item: F1:infinitive > (arbeiten); F2:1stPerson > (arbeite); F3:2ndPerson > (arbeitest) -> (gives 3 fields in the database, and 3 fields in the layout. DISADVANTAGE: 3 fields for each verb, even if it is a regular verb)
  2. 1 textfield(3 repetitions) for the root, and 3 for the suffixes: F1(3 repetitions):root > (arbeit); F2:suffixInfinitive > (en); F3:suffix1stPerson > (e); F4:suffix2ndPerson > (est) -> (gives 4 fields in the database, and 4 fields in the layout. ADVANTAGE: Only 1 field for each regular verb, the others are globals. DISADVANTAGE: layout building more cumbersome)
  3. 1 textfield for the root, and 3 for textcalculations: F1:root(arbeit) F2:(F1 & en) F3:(F1 & e) F4:(F1 & est) -> (gives 4 fields in the database, and 3 fields in the layout. ADVANTAGE: Only 1 field for each regular verb, the others are globals)
  4. 4 textfields (1 for the root and 3 for the suffixes) and 3 for textcalculations: F1:root > (arbeit); F2:suffixInfinitive > (en); F3:suffix1stPerson > (e); F4:suffix2ndPerson > (est); F5:(F1 & F2); F6:(F1 & F3); F7:(F1 & F4) -> (gives 7 fields in the database, and 3 fields in the layout. ADVANTAGE: Only 1 field for each regular verb, the others are globals)

 

Does the number of fields affect overall performance?

Do calculations affect overall performance compared to textfields?

 

Thanks

Jurgen

 


 

 


Outcomes