Subject Re: [firebird-support] Re: Which way is best...
Author Martijn Tonies
> > How long does it take?
> In my world - long time.
> It takes some 90 minuttes.
> >
> > Is this a one time operation? If so, and it takes little time, why
> bother?
> The rutine is not used very often.
> I would say twice a year.
> But every time its being run, we get complaints from other clients.

In that case, try a client application (unidirectional = true), use
a prepared INSERT statement and set its parameters.
Do the trick with batches of about 1000 rows, commit after each
batch if you like and sleep a bit between each batch.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Upscene Productions
Database development questions? Check the forum!