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?