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