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]
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]