Re: Problem with mysql and php
| From: | Jason Pruim | Date: | Tue, 29 Nov 2011 02:08:52 +0000 |
| Subject: | Re: Problem with mysql and php | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-48103@lists.php.net to get a copy of this message | ||
Jason Pruim
pruimj@gmail.com
On Nov 28, 2011, at 8:58 PM, Phil Dobbin wrote:
> 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?
>
> ;-)...
In all seriousness... Would it help or change it in anyway? :)
I am free to use what I want (I believe) on this project...