List:General Discussion« Previous MessageNext Message »
From:Sebastian Mendel Date:May 22 2007 6:39am
Subject:Re: Upgraded to 5.0.x from 4.1.x and ORDER BY sucks!
View as plain text  
Gmail User schrieb:
> I had perfectly working complex queries both with LEFT JOIN and without
> and they were returning results in under a second. After upgrade to
> 5.0.x, the same queries would return results in 20-30 second range.

possible you had set up some query cache in 4, but not currently in 5?

how did you 'upgraded' your data?


> Through trial and error, I discovered that in case of SELECT ... FROM
> table1, table2 ... ORDER BY table2.column will be very slow (10s of
> seconds), while the same query ordered by table1.column will be in under
> 1 second. If I switch the order of tables in FROM, the same will hold
> true in reverse order.

what means this exactly?
in reverse ordered tables, query is fast on second or on first table order?


> Is this a bug or I missed something in my
> googling? More importantly, what can I do change this--I need those
> sorts! :-(

did your tried an EXPLAIN?



-- 
Sebastian Mendel

www.sebastianmendel.de
Thread
Upgraded to 5.0.x from 4.1.x and ORDER BY sucks!Gmail User22 May
  • Re: Upgraded to 5.0.x from 4.1.x and ORDER BY sucks!Sebastian Mendel22 May
    • Re: Upgraded to 5.0.x from 4.1.x and ORDER BY sucks!Gmail User22 May
  • Re: Upgraded to 5.0.x from 4.1.x and ORDER BY sucks!David Sparks22 May
    • Re: Upgraded to 5.0.x from 4.1.x and ORDER BY sucks!Gmail User24 May
re: Upgraded to 5.0.x from 4.1.x and ORDER BY sucks!J.R. Bullington22 May
  • Re: Upgraded to 5.0.x from 4.1.x and ORDER BY sucks!Gmail User22 May