ok all you MySQL gurus...I have a question.
I am creating a large MySQL database to hold stock quote data, and I have an efficiency question.
Is it better to have 500 tables of 18250 rows per table, or 1 table with 9125000 rows. To clear a few questions up, none of the data will ever be inserts, only queries, and since each table would be for one specific stock, I would always know which table to query (ie. use wants info on stock XYZ, query table XYZ...select * from XYZ where blah blah).
If hardware matters the server is a dual processor pIII with 1gb ram, and 7200rpm ide (not scsi :-( ) hard drives.
thanks,
~Matt
I am creating a large MySQL database to hold stock quote data, and I have an efficiency question.
Is it better to have 500 tables of 18250 rows per table, or 1 table with 9125000 rows. To clear a few questions up, none of the data will ever be inserts, only queries, and since each table would be for one specific stock, I would always know which table to query (ie. use wants info on stock XYZ, query table XYZ...select * from XYZ where blah blah).
If hardware matters the server is a dual processor pIII with 1gb ram, and 7200rpm ide (not scsi :-( ) hard drives.
thanks,
~Matt