On Fri, 7 May 2004 18:48:29 +0000 (UTC), Epstein, Ed wrote:

> 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.

On a 2xCPU (ca. 800MHz Xeon) server we transferred about 2000
records/second from one database to another (read 2000 + write 2000). The
program Delphi+IBO+IB/5.6, but not optimized for this particular table;
record length ca. 500B, filled about 50%; no indexes, just PK. Everything
running locally (no network traffic).

> 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.

I think IB Workbench is Delphi+IBO.



--
Aage J.