… main MSSQL server (say every 5 min) and using some scripts to manipulate the resultant csv to a partially de-normalised state and then loading them into the MySQL… (select … .. ) a left outer join (select … ) b on b.a = a.a etc.. (in total I have like close to…
Comment: Just do the math!
July 11, 2009 By 4 Comments
…select in the example would go in msecs instead of minutes or hours. So I as a user of a mysql database only need to care to throw in the data (like from the apache log in realtime). Compared to today where I most likely…to the large log db and one to the aggregated db). If im not mistaken mssql…
