MySQL - over 1,000.000.00 records?

[Anon]

Hi,

I'm thinking of importing over 1 million records into the MySQL database, and then do queries against it. Any suggestions? Will MySQL handle that many records just fine?

Thanks

[brandonschnell]

mysql can. just make sure your code can also.

1) check the articles on www.phpbuilder.com on how to create clean table structures that keep the data as seperate as possible.

2) index columns that are used the most often in searches.

3) limit the resulting data to the user as much as possible. "SELECT * FROM table;" isn't kosher here.

[Anon]

Ha, that'd be interesting... I wouldn't mind trying that with say.... 50 or a 100 million records and seeing what happens.... Would make a fun weekend ;-) Mysql has a records limit doesn't it? I can't remember what it is.....

Billy

[Anon]

I know of a web site that searches over 9 million (can't tell you which one though).

Just make SURE you index the tables and make sure your schema and code as efficient as you can!

[chriskl]

From the MySQL manual:

"We have now been using MySQL since 1996 in an environment with more than 40 databases containing 10,000 tables, of which more than 500 tables have more than 7 million rows. This is about 100 gigabytes of mission-critical data. "