Potential for optimizing a huge table for querries?
| From: | Andy | Date: | Thu, 27 Dec 2001 10:57:30 +0000 |
| Subject: | Potential for optimizing a huge table for querries? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-15234@lists.php.net to get a copy of this message | ||
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