Thanks for the bits, Don. Putting everything into a single
transaction was good for a factor of two or more in my case.
I'll look into the COPY command. I think the Perl DBI interface
has a lot less CPU overhead than preparing SQL statements in
ACS/Tcl, so that is also a factor. I am getting something like 500
rows/second inserted via OpenACS, vs. 2000 per second using Perl DBI
(on a 1.4 GHz Linux box with single IDE drive).
Luckily, this is pretty much fast enough for what I'm trying to
do for the moment.
