Is MySQL enough for a huge amount of data?
| From: | Andy | Date: | Fri, 14 Dec 2001 12:27:03 +0000 |
| Subject: | Is MySQL enough for a huge amount of data? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-15024@lists.php.net to get a copy of this message | ||
Hi there,
I am wondering if I could have MySQL as a DB for an Application which needs
to have access a table of 1 Mio entries.
And how long would it take to get an entry out of it. Asuming it contains
only a name field and an id.
e.g.
select name
from cities
where provincial id = 2
If it works, how could I optimize the table?
Thanx for you help guys
Cheers Andy