Re: Load overshooting ONE server

On 07/09/16 17:09, John Levine wrote:
>> IN particular I found that a nested query was far better performed by
>> the application than by Mysql, on a multi-million record table
>
> Depends on the query. I've gotten some impressive speedups by
> breaking a nested query in half by putting the nested query into a
>
> CREATE TEMPORARY TABLE temptable (SELECT ... blah ...),
>
> and making the outer query do
>
> ... WHERE foo in (SELECT foo FROM temptable)
>
> Mysql optimizes that pretty well.
>
>
Well in essence that is what I did, except the temporary table contents were held in application memory instead of mysql memory

-- 
Karl Marx said religion is the opium of the people.
But Marxism is the crack cocaine.