Hi all,
I've been using the SAP DB 7.3(0.29) for a while. I'm interesting to hear from people
who have expirience with both 7.3 and 7.4. How do these versions compare in
stability and performance. The application I'm working on consists of the 2 stages:
concurrent data upload (typical OLTP) and the use of the database in the read- only
mode (quite complex queries that involve a lot of aggregations, something like data
warehouse functionality) as the upload completes. Therefore I'm interested both in
I/O performance and highest possible level of concurrency for the first stage and in
the perfomance on the complex queries (for the read only "analytical" mode). Has
anyone any specific experiences with these versions (7.3/7.4)...some problems
like performance degradation under heavy load, etc?
More specific question:
(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?
(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?
Thanks in advance,
Dnmitri
Nuix Pty. Ltd.
With Yahoo! Mail you can get a bigger mailbox -- choose a size that fits your needs
