[PHP-DB] Potential for optimizing a huge table for querries?

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:

Re: [PHP-DB] Potential for optimizing a huge table for querries?

Mysql has support for indexes on two or more fields. So you can create index on country_code AND province. At the moment I cannot remember the syntax but look at the docs www.mysql.com/doc/ to find it. HTH Regards, Andrey Hristov - Original Message - From: Andy [EMAIL PROTECTED]