I will build a site which has 700,000 records, want to use php+mysql,
but I have a question about the speed of mysql, does it will be a problem when I use mysql with about 700,000 records?
Who can explain to me? THanks!
How many records does mysql support normally, and not affect speed?
Originally posted by rocklv
I will build a site which has 700,000 records, want to use php+mysql,
but I have a question about the speed of mysql, does it will be a problem when I use mysql with about 700,000 records?
Who can explain to me? THanks!
In every database, more records equals slower performance, and there's nothing you can do about it. Indexes help, but if you're asking the database to join 700,000 rows against 700,000 rows, it will be slower than joining 7,000 rows against 7,000
MySQL, like most databases, is slower at larger data sets primarily because it's waiting on I/O, not because it's inefficient.
row width is important too. A 700,000 row table that stores your name and number is gonna be a lot smaller than one that contains all your contact information plus a MIME encoded MRI image or two.
MySQL, Interbase, Postgresql, SAPdb, all of these can handle millions and millions of rows. How efficient they are on complex queries should be your real question.
Any database can give good performance on "select * from table where id=234573872" It's how it behaves on things like "select id from table except (select id from table2) where table.name like 'Smith%';" that count.
There are my.cnf conciderations once you start getting really big tables. Reference the my-huge.cnf, my-large.cnf, my-medium.cnf and my-small.cnf files distributed with your copy of mysql.
FYI, I have a table with 2.1M+ records and it's running fine.