You could very well shorten the overall elapsed time if you can
configure your
script into 2 (or more) scripts, each doing 1/2 of your updates, and run
them
in parallel.
Cheers,
Kent
-
Before posting, please check:
http://w
Thiru,
Try using DELAYED parameter with your INSERT. - it batches them up more efficiently
in another thread.
Dave.
Thiru wrote:
> Hello,
>
> I am creating a script which works offline from the mainstream of our system
> and updates our databases.
> These scripts includes INSERTING, UPDATING a
