Re: Potential for optimizing a huge table for querries?
| From: | Andrey Hristov | Date: | Thu, 27 Dec 2001 11:23:54 +0000 |
| Subject: | Re: Potential for optimizing a huge table for querries? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-15236@lists.php.net to get a copy of this message | ||
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" <news.letters@gmx.de>
To: <php-db@lists.php.net>
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: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>