Re: Insertion takes very very long time
Posted by:
Bill Karwin
Date: September 05, 2006 11:39AM
No, set autocommit to FALSE when you are insterting a large number of rows.
And remember to COMMIT after the rows have been inserted.
Also, there's a manual page with other tips on how to improve the performance of INSERT:
http://dev.mysql.com/doc/refman/5.0/en/insert-speed.html
Regards,
Bill K.
Subject
Written By
Posted
September 03, 2006 01:22AM
September 04, 2006 02:13PM
September 04, 2006 09:31PM
Re: Insertion takes very very long time
September 05, 2006 11:39AM
September 05, 2006 12:47PM
September 05, 2006 03:25PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.