Hi Tobias, sorry for answering so late. We tried to reproduce your experiments. But we only got the high rate (600 inserts/sec) when the write-cache was switched on. After switching it off, the insert-rate fell down to 81 inserts/sec as expected. Because we rely on the operating-system for completition of the IO-calls, the administrator has to assure, that there is nowhere a cache involved, which hides the completion of a write-operation. One assumption for the effects on your system is, that the windows-driver of your HD2 isn't able to control the write-cache properly.
regards, Martin > > > > > > I used the following setup: > > > > Hardware: > > > > HD1: IBM DORS-32160 SCSI, an old 2GB drive with 5.400 RPMs > > HD2: IBM DTLA-307030 ATA-100, a younger 30GB drive with 7.200 RPMs > > > > in a Intel PIII-800, .5G RAM, Promise UDMA100, Adaptec 1542. > > > > > > Software: > > > > 1) Stock 7.4 binary release for Windows (Kernel 7.4.3 Build > > 010-120-035-462) > > 2) Oracle 9iR2 Personal Ed. for Windows > > > > both on Windows 2000SP2. > > > > > > Task: > > > > I INSERTed 10.000 records into a table mytab (f1 integer, f2 > > varchar(100)) > > from a Notebook connected via 100MBit running two different > breeds of > > clients > > (to divide out client specifica): > > > > Client A: C++/OTL based client with streamsize == 1, > > autocommit == OFF, > > prepared SQL and COMMIT after every INSERT. > > > > Client B: Java/JDBC based client with autocommit == OFF, > prepared SQL, > > COMMIT nach jedem INSERT. > > > > > > Results: > > > > Client A -> SAPDB on HD2 w/ write cache OFF 600 INSERTs/sec > > Client A -> SAPDB on HD1 w/ write cache OFF 89 INSERTs/sec > > Client A -> Oracle on HD2 w/ write cache OFF 115 INSERTs/sec > > Client A -> Oracle on HD1 w/ write cache OFF 82 INSERTs/sec > > > > Client B -> SAPDB on HD2 w/ write cache OFF 620 INSERTs/sec > > Client B -> SAPDB on HD1 w/ write cache OFF 89 INSERTs/sec > > Client B -> Oracle on HD2 w/ write cache OFF 112 INSERTs/sec > > Client B -> Oracle on HD1 w/ write cache OFF 80 INSERTs/sec _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
