MySQL Forums
Forum List  »  Performance

Re: Implementing distance matrix 2500 X 2500
Posted by: STARYNKEVITCH Basile
Date: December 14, 2004 12:30AM

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/

Options: ReplyQuote


Subject
Views
Written By
Posted
4858
December 13, 2004 11:06AM
Re: Implementing distance matrix 2500 X 2500
2362
December 14, 2004 12:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.