> ""Ali Gökçen"" <alig@...> wrote in message
> news:<dar6d0+ius9@...>...
> > Hi Bupp,
> > Firebird has selectable procedures, unlike other systems.
> > have you tried to do SUSPEND for every 10000 inserts and
> > commitretaining them from client?
> > only an idea, i am not sure if it is work.. i leaved the programming 6
> > years ego.
> >
> > Ali
> >
>
> No, that won't work. The software is designed to work with many
> database and
> I believe "CommitRetaining" is only available thru the API and not a SQL
> call (which I need), because in order to work with multiple
> databases I use
> either ODBC or OLEDB.
>
> Thanks
> Bupp

so I suppose this is another secret revealed Bupp?
your name
and the fact that you are relying on ODBC only for connection. I assume that
you do not use any connection methods (other than connect) nor do you create
any explicit client transactions.
Can I enquire as to the language you are using to make your ODBC
connections?
Can I also assume now that all your tests are have also been under ODBC
connection with no transaction control? This might help us all with further
comments on your queries.
Alan