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.
Advertising
HTH Regards, Andrey Hristov ----- Original Message ----- From: "Andy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 27, 2001 12:57 PM Subject: [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: > 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] > > -- 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]
