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 and DELETING records.
>
> I am performing a updating operation using Python which takes really some time.
> Something like,
> update TABLE1 set col1=val1 where col2=something;
> col2 is indexed.
> val of something is set inside Python script.
>
> This statement is executed atleast 250000 times.
>
> I beleive for the amt of work it is doing it is really fast, but
> by any means is there a way to step up the updation speed further??
>
> like changing or adding some config options to my.cnf etc..
>
> Please help.
>
> Thiru
>
> -----------------------------o0o----------------------------------------
> "There is no finish line, you can always learn"
> "You have to keep pressure on yourself, you have to work on your weaknesses".
>
> Thiru
> S/W Engineer, Service Dvlpment Group
> Infoseek,Japan Voice - (81)-3-5453-2056
> http://www.infoseek.co.jp <- Click Here
> http://www.rakuten.co.jp <- Click Here
> http://house.infoseek.co.jp <- Click Here
> http://profile.infoseek.co.jp <- Click Here
> http://chat.infoseek.co.jp <- Click Here
> --------------------------------------------------------------------
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
