Hi everyone, I've never fooled with sqlite before and I'm trying to do a
simple query on an sqlite db, but I don't seem to be doing anything
correct. I can't figure out how to just simply open a db file in the
directory and query it and echo back the contents. Here's some code I've
been messing wit
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 re
On 29/11/11 01:38, "Jason Pruim" 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 tho
Jason Pruim
pru...@gmail.com
On Nov 28, 2011, at 8:58 PM, Phil Dobbin wrote:
> On 29/11/11 01:38, "Jason Pruim" wrote:
>
>> Given the following 2 queries:
>>
>> "SELECT DISTINCT areacode FROM main WHERE state = '{$query_exploded[0]}'";
>>
>> "SELECT DISTINCT areacode FROM main";
>>
>> The
On 29/11/11 02:08, "Jason Pruim" wrote:
>> 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...
It's well worth looking into. Postgres can handle far bigger db's much
quicker than MySQL but
On Mon, Nov 28, 2011 at 9:19 PM, Phil Dobbin wrote:
> On 29/11/11 02:08, "Jason Pruim" wrote:
>
>>> 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...
>
> It's well worth looking into. P
Le 2011-11-28 à 22:38, Bastien Koert a écrit :
On Mon, Nov 28, 2011 at 9:19 PM, Phil Dobbin
wrote:
On 29/11/11 02:08, "Jason Pruim" wrote:
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...