question about mysql table and performance

Hi,

For implementation a bigger mysql table for using with query drop down field I have two possibilites:

1) scheme1
code, column_de1, column_de2, column_de3, column_xx1, column_xx2, column_xx3, ...
about 3000 rows per column, gives with 7 languages = 3000 rows
in comprofiler table 22 new columns

2) scheme 2
code, lang, column1, column2, column3
for every language 3000 rows, gives with 7 languages = 21000 rows
in comprofiler only 5 new columns

What is the best decision for the best website performance? Do I have to keep the columns number in comprofiler table as low as possible?

Thanks, best regards
Eric

Number of rows is never an issue as long as the queries you're using are properly indexed. There are a maximum number of columns that you can add to a table though before you hit row size limits. So my suggestion is schema 2. Why are you storing language specific information in the database though? You should be storing a generic language agnostic key that you translate on display.

Hi,
Thanks for the recommendation.
I have learned, that only the system with single-select or multi-select drop down with the query including language substitutions if-clauses and storing language data in mysql works also in multilanguage userlist search.
If I store the language codes and make translations with the language overrides, the search don't work with the language names, right?
That is my understanding, please check and let me know, if I am too complicate.
Thank you very much.
Best regards
Eric

If you're using a select fieldtype then the stored value should be language agnostic. The displayed value will translate fine. Example as follows.

Value: value_1
Label: Hello

The above results in the dropdown showing Hello while storing in the database value_1. The label "Hello" can be translated using CB language overrides. You do not need to store any kind of language specific value for this to work. During searching users would use that same dropdown where translation API would again apply.