4 million rows is a large table, but not a huge table. 400 is a large number of tables.
Does the data in the 400 arrays describe the same type of entity or do they provide *generic* attribute info for different types of entities? If so, they would logically belong in a single table, otherwise not. I would start out by using the logical grouping, and worry about partitioning the table(s) later - if required for performance. HTH, Tore. ----- Original Message ----- From: "gregory lefebvre" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 24, 2003 10:07 AM Subject: Large table or several tables ? > Hye the list, > > There is my problem. > > I have to register about 400 large arrays (~10000 lines each) in my > MySQL database and I don't know which of the following choices is better. > Either create a large tables as a stack, which contains all arrays > Either create as many tables as there are arrays and use references to > each table. > > Any advice is welcome. > Thank you very much > > Greg > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
