Subject | RE: [firebird-support] Re: Inserting 100's of thousands from a SP |
---|---|
Author | Alan McDonald |
Post date | 2005-07-10T13:49:59Z |
> ""Ali Gökçen"" <alig@...> wrote in messagerubbish - you can CommitRetaining thru ODBC to FB - is it other DB's which
> 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
can't?
Alan