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
Hello,
I am creating a script which works offline from the mainstream of our system
and updates our databases.
These scripts includes INSERTING, UPDATING and DELETING records.
I am performing a updating operation using Python which takes really some time.
Something like,
update TABLE1 set col1=
