I have long had problems with inserts into my database. I was never able to
get above 300 inserts per second regardless of how I tried to do it.
Someone in here had mentioned multi-threading the inserts and I had tried
with multiple instances of IB Workbench to do this. No increased
performance. However, I just upgraded the machine not too long ago. I now
noticed that I could get several instances of IB Workbench running without
hitting a ceiling on inserts per second yet. I was able to get up to 1500
inserts now without a problem.

Since I use VB6 and not IB Workbench to insert my data on a regular basis I
am wondering if the OLEDB providers are specifically limited to a "single"
thread for transactions? Running multiple instances of my front-end only
seems to net about one instance of IB Workbench's performance.