June 19, 2013

Comment: Why MySQL could be slow with large tables ?

…of the main MSSQL server (say every … the main server or even the mysql server…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

Comment: Just do the math!

… page entry so the select in the example would go in msecs instead of minutes or hours. So I as… throw in the data (like from the apache log in realtime). Compared to today where I most likely would need to take… one to the aggregated db). If im not mistaken mssql does similar stuff since a while back…