Dan,
So in reference to your comment below, just how bad of an impact are we
talking here?
It adds a lot of I/O because every commit writes to disk. And connections are synchronizing on the log writer. Think about a chain gang.
And if it is really bad then why would that be the default
mode? (something to do with the jdbc spec I suppose)
ODBC actually. I blame it on Microsoft, as their desktop databases didn't knew about transactions, so they were autocommit only. But as ODBC was derived from a SQL Access Group specification, maybe the origins of this default are somewhere else.
Daniel Dittmar
-- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
