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]