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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
