Re: [PHP-DB] Problem with mysql and php

2011-11-29 Thread Jason Pruim
Jim, Similar yes... But this was specifically about replacing distinct with something since it was taking WAY to long... But it did evolve into a very similar conversation :) Jason Pruim pru...@gmail.com On Nov 29, 2011, at 6:25 PM, Jim Giner wrote: > Didn't the OP begin this very same sub

RE: [PHP-DB] Problem with mysql and php

2011-11-29 Thread Amos Jean-Baptiste
> From: joker_mos...@hotmail.com > To: phps...@gmail.com > Date: Tue, 29 Nov 2011 23:07:13 -0500 > CC: phildob...@gmail.com; php-db@lists.php.net > Subject: Re: [PHP-DB] Problem with mysql and php > > > > Le 2011-11-28 à 22:38, Bastien Koert a écrit : > >

Re: [PHP-DB] Problem with mysql and php

2011-11-29 Thread Jim Giner
Didn't the OP begin this very same subject a month ago? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Problem with mysql and php

2011-11-29 Thread Dan Rowe
Try running this : http://mysqltuner.pl/mysqltuner.pl If the server has been up for over 24hrs it gives a lot of good insight and things to try tuning wise as a starting point. It'll uncover a lot of common configuration issues or MySQL server level bottlenecks. -Dan (apologizes for the top post

Re: [PHP-DB] Problem with mysql and php

2011-11-29 Thread Tamara Temple
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 though Currently wo

Re: [PHP-DB] Problem with mysql and php

2011-11-28 Thread Amos Jean-Baptiste
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...

Re: [PHP-DB] Problem with mysql and php

2011-11-28 Thread Bastien Koert
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

Re: [PHP-DB] Problem with mysql and php

2011-11-28 Thread Phil Dobbin
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

Re: [PHP-DB] Problem with mysql and php

2011-11-28 Thread Jason Pruim
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

Re: [PHP-DB] Problem with mysql and php

2011-11-28 Thread Phil Dobbin
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

[PHP-DB] Problem with mysql and php

2011-11-28 Thread Jason Pruim
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