May 26, 2012

Comment: Why MySQL could be slow with large tables ?

July 6, 2007 By 139 Comments

…, I think this may be the main cause of the slowness. Hence, I’m considering to actually do a query which… current PC) (select a, join b, where c…) eg: select a.a, b.x, etc.. from (select … .. ) a left outer join (select … ) b on b.a = a.a etc.. (in total I have like close to 11 subqueries joining a min…

Filed Under: Insight for DBAs Tagged With: ,