INSERTs/UPDATEs are a bit slow ... SAPDB might as fast as MySQL if you set the LogMode to DEMO (which means, that no transaction-log is written), but that's not a good idea in general.

I thought that the difference between demo and single was when the log was full:


in demo mode you have : if (log is full) {
truncate log file
}


in single mode you have :
if (log is full) {
  take the big kernel lock
  backup log
  truncate log file
  release the big kernel lock
}

oops, i think i wrote rubbish.



_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to