;> GROUP BY (group field)
>> HAVING calcfield BETWEEEN 1 AND 10
>>
>> the query takes 3sec!
>>
>> Is there a way to handle this situations in witch one thread takes
>> over the whole server??
>
> HAVING clause is applied before data are sent
field
> FROM table1 INNER JOIN table2 ON ... INNER JOIN table3 ON
> WHERE table1.field = 'something'
> GROUP BY (group field)
> HAVING calcfield BETWEEEN 1 AND 10
>
> the query takes 3sec!
>
> Is there a way to handle this situations in witch one t
ld = 'something'
GROUP BY (group field)
HAVING calcfield BETWEEEN 1 AND 10
the query takes 3sec!
Is there a way to handle this situations in witch one thread takes over
the whole server??
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
