Re: [INTERFACES] Performance

> second.  I then wrapped the whole series of inserts in a BEGIN/END
> block.  This increased the speed to about 1000 inserts per second.
> Yup.  A thousand.  That's 40 times the speed.  Pretty cool.  :-)

How did you measure this? Did you do (pseudo code):

start_time = now
SQL BEGIN
SQL INSERT's..
...
SQL END
end_time = now
print number_inserts / (end_time - start_time)

or
SQL BEGIN
start_time = now
SQL INSERT's
....
end_time = now
SQL END
print number_inserts / (end_time - start_time)

This makes a difference, since a lot of processing is done on commit time. The second
variant might thus be misleading.

Maarten

-- 

Maarten Boekhold, boekhold@tibco.com
TIBCO Finance Technology Inc.
The Atrium
Strawinskylaan 3051
1077 ZX Amsterdam, The Netherlands
tel: +31 20 3012158, fax: +31 20 3012358
http://www.tibco.com