Re: Problem with mysql and php
| From: | Phil Dobbin | Date: | Tue, 29 Nov 2011 01:58:14 +0000 |
| Subject: | Re: Problem with mysql and php | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-48102@lists.php.net to get a copy of this message | ||
On 29/11/11 01:38, "Jason Pruim" <lists@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? :)
PostgreSQL?
;-)...
Cheers,
Phil...
--
Nothing to see here... move along, move along