Jason Pruim <li...@pruimphotography.com> wrote:

> Given the following 2 queries:
> "SELECT DISTINCT areacode FROM main WHERE state = '{$query_exploded[0]}'";
> "SELECT DISTINCT areacode FROM main";
> The second displays ALOT faster.... Like by minutes... the first one is what 
> I really want though.... Currently working with a dataset of 89 million 
> records, will be expanding that to many many more times that... To the tune 
> of possibly a couple billion records...
> Any ideas? :)

make state an index into the table.

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to