Jason Pruim
pruimj@xxxxxxxxx
On Nov 28, 2011, at 8:58 PM, Phil Dobbin wrote:
> On 29/11/11 01:38, "Jason Pruim" <lists@xxxxxxxxxxxxxxxxxxxx> 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...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
