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(at)tibco(dot)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