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]

Reply via email to