On Jul 14, 2006, at 22:53 UTC, Kees Nuyt wrote: > How many SQL commands are in your typical transaction?
One. > Do you start them with a "BEGIN" ? No, I'm using implicit transactions. > If you never do a "BEGIN", every SQL command is > one transaction, and "COMMIT" has no meaning. Yes, I'm aware of that, but it shouldn't hurt either (right?). Yet my observations indicate that the database hadn't written anything to disk in two days (or if it had, it somehow decided to roll back the last two days' worth after the crash). Any insight on that? Best, - Joe -- Joe Strout -- [EMAIL PROTECTED] Verified Express, LLC "Making the Internet a Better Place" http://www.verex.com/
