Subject RE: [firebird-support] Re: Inserting 100's of thousands from a SP
Author Alan McDonald
> ""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

rubbish - you can CommitRetaining thru ODBC to FB - is it other DB's which
can't?
Alan