Felix John wrote:
> What do you think on having a table with 2500 columns and 2500 rows ???
It is possible, but uncommon, and could be less efficient thant a 2500*2500 rows table of a few (3-4) columns. You might also store your data in a plain file, or a single table of one big row of a large BLOB column containing the whole data.
I am not a MySQL expert, but the common idea in RDBMS is that tables are relations, and should match the programmer's way of thinking. I doubt that a programmer consider his 2500 data individually...Tables are more like types or classes than like individual data structures or instances.
What would you think of a Fortran or Java or C function or method with 2500 local variables or arguments? It is in principle doable, but no programmer would think or code that way!
--
Basile STARYNKEVITCH ::::
http://starynkevitch.net/Basile/