|Subject||Re: [firebird-support] Re: Which way is best...|
> > How long does it take?In that case, try a client application (unidirectional = true), use
> In my world - long time.
> It takes some 90 minuttes.
> > Is this a one time operation? If so, and it takes little time, why
> 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.
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.
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Database development questions? Check the forum!