Subject Re: [firebird-support] Re: Inserting 100's of thousands from a SP
Author buppcpp@yahoo.com
""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