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.

select name
from cities
where provincial id = 2

If it works, how could I optimize the table?

Thanx for you help guys

Cheers Andy

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to