> 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