robert_difalco wrote:

> I'm noticing that INSERT performance is very much IO bound (at least
> on 1.0.x).

Interesting. What operating system? How are you measuring I/O
performance? What interface are you using? What Firebird architecture
(i.e. Classic or Superserver) How may indexes are active?

The fastest way to insert records into firebird is with a local classic
connection (or embedded under Windows), running a preprocessed
application written in C.

> So here is my question. I have multiple machines posting
> data to a server, the server then inserts data into the database on
> multiple threads. It uses a thread for each connection. As a result,
> my inserts into the database happen on multiple threads.
>
> Would bulk insert performance be increased if I forced all these
> inserts into a single thread, making them synchronous?

Yes, probably, but depends on the answers above.


Regards,


Ann