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
> 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 :
>
>
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
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
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
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...
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
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
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 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
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
11 matches
Mail list logo