On Sun, Jul 13, 2008 at 3:15 PM, Stefan Heymann <lists@...> wrote:

> I have an SQL script that inserts a few thousand rows into my Firebird
> database.
>
> It will run when nobody else is connected to the database and when
> there are no other transactions running concurrently.
>
> Execution time does NOT matter.
>
> Is it better to COMMIT every single insert?

I don't remember who said it, but I remember someone advising to
commit every 500 statements or so. If I am wrong, then please execuse
me.

Fidel.