> > 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
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com