I am using VB6, AD0 V2.5 and SIBProvider (Have also tried IBPHOENIX
free & trial). Using ADO Connection & command objects I have tried
to perform insert statements on tables in my backend. I have tried
it with a simple insert statement, a statment executing a stored
procedure, and a command object executing a store procedure with
named parameters. The last is by far the fastest, but gets 250-300
transactions /s. I really need advice on what is the fastest way to
use VB6 and an OLEDB Provider. Since i need to work with millions of
records I need a way to move them into the backend in minutes, not
hours, days & months. Any help is appreciated