Subject | Re: [firebird-support] Re: Inserting 100's of thousands from a SP |
---|---|
Author | buppcpp@yahoo.com |
Post date | 2005-07-10T13:25:31Z |
""Ali Gökçen"" <alig@...> wrote in message
news:<dar6d0+ius9@...>...
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
news:<dar6d0+ius9@...>...
> Hi Bupp,No, that won't work. The software is designed to work with many database and
> 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
>
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