Hi guys,

I would like to optimize a tabel with 2.3 mio entries for querries

The table is not gonna be changed afterwards, no entries are gonna be added.
It just supports info.

currently it looks like that:

ID: int(7)
city: varchar(50)
country_code char(2)
province: char(2)

indexes:
country_code
province

Type: MyISAM

Querry on country_code AND province

Does anybody know if this has potential to optimize?

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