Problem with mysql and php
| From: | Jason Pruim | Date: | Tue, 29 Nov 2011 01:38:33 +0000 |
| Subject: | Problem with mysql and php | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-48101@lists.php.net to get a copy of this message | ||
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? :)
Jason Pruim
lists@pruimphotography.com