Re: Performance advice

On Mon, 23 Jun 1997, David Williams wrote: > Correct - KAIO is definately perferable. In theory -- do your own timings. We've found situations where non-kernel is significantly (10-15%) faster. YMMV. > >If most I/O is "writing I/O", try to force sorted writes. This can be > >done by increasing LRU_MAX_DIRTY and LRU_MIN_DIRTY. Your checkpoint > >duration will increase, however, and for other OLTP applications > >this might cause some disadvantages, but your INSERTs will become > >quicker. > Or increase number of BUFFERS!! Which can also slow down your checkpoints. Ideally, grab some self-cacheing disks (ala EMC or whatever) and crank BUFFERS way /down/. For us, this sped up our checkpoints and our application. Again, YMMV. > >Using the TCP-B Benchmarks we found the following when we compared > >dynamic SQL vs. Stored Procedures: Yay! Actually timing .. a very good thing IMO. -Richard