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
