(1) What's impact on the performance switching the REDO LOG OFF(7.4) if the application primarily does a lot of conncurrent INSERTs? Would it be the sufficient
perfomance gain?
i think INSERTs can be accelerated, if you don't use AUTOCOMMIT, but but many INSERTs into one transaction.
the log is only synced, if a commit is done (as far as i know)
(2) As the SAP DB is highly multithreaded and 7.4 uses only native OS threads
is there any positive effect of applying Linux's "Low latency/kernel preemption"
patches for better performance under the heavy load?
as far as i know, this patch means, that the kernel is internally preemptiv, and i guess that the perfamnce-gain for applications is minimal.
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
