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

--- In firebird-support@yahoogroups.com, <buppcpp@y...> wrote:
>
> > Transactions can only be managed (started and committed or rolled
> > back) by a client application.
> >
> > Adam
>
> Thanks for the clarification.
>
> It really would be nice if FB supported COMMIT's in SP, it would make
> database migration so much easier since most other databases support
this
> feature.
>
>
> Thanks
> Bupp