chasesmith2002 schrieb:

> I am using VB6, AD0 V2.5 and SIBProvider (Have also tried IBPHOENIX

free & trial).


ADO is not a really fast solution. Using the API is much more efficient.

For my own programming (also using VB6) I did decide to end the ADO
nightmare and write an Driver for my own to interface directly to the
API from within the VB application. None of the OLEDB-Providers
available did work fast and reliable for me. For an Delphi-Part in my
Application changing from ADO to DAO did raise speed by order of
magnitude.

> The last is by far the fastest, but gets 250-300 transactions /s.

If the inserts are only required once to load the initial data into
Database the file-based solution mentioned by Alan should be the best.

Else you should make shure that your Server is able to handle that
amount of transactions. To do this you should use the API directly or
via embedded SQL since this definitely is the fastes method - all
OLEDB-drivers are calling the API to access the server.

Elmar