Sven K�hler wrote: ... > "safe" might conflict with "fast". Often MySQL users asked, > why SAPDB is > so slow on INSERTs - the reason is clear, because it does > it's job well, > and flushes the data to disk on every COMMIT. >
WE do NOT flush all data to disk on every COMMIT, no matter what people of MySQL guess and no matter if AUTOCOMMIT is used or not. We have LOG which has to be written, but no need to write the data itself for each COMMIT. BTW: LOG is usually much smaller than the pages of changed data. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
