From markl@hep.ucl.ac.uk Fri Mar 16 23:54:21 2001
Date: Sat, 9 Dec 2000 13:12:10 +0000 (   )
From: Mark Lancaster <markl@hep.ucl.ac.uk>
To: Jim Amundson <amundson@fnal.gov>, ksmcf@fnal.gov, lmark@cdfsga.fnal.gov,
     Marjorie Shapiro <Mdshapiro@lbl.gov>, r.stdenis@physics.gla.ac.uk,
     rharris@fnal.gov, Rob Snihur <snihur@fnal.gov>, sexton@fnal.gov,
     stefano.belforte@ts.infn.it, watts@physics.rutgers.edu, wolbers@fnal.gov
Subject: Timings from offline production oracle server to fcdfsgi2


Just did the same timings but using cdf production (offline) server as
opposed to the development server and it's much quicker but still slower
than msql.

Insert Time (1000*1 row) = 83 sec; Readback = 54 sec.

I think the insert and readback I am doing in this test is very unoptimal
for oracle since it is reading back and inserting a row at a time, not
doing block insert/reads and thus in this case you get the overhead of all
the oracle integrity checks to the maximal extent.

Cheers
	Mark