MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Batch Insert
Posted by: jomy george
Date: October 18, 2011 02:58AM

Hi Friends,

I have to insert some data in to MYSQL table. Number of records may be somewhere between 50k to 70k. I would like to know what should be the optimum count of records in one batch insert. Can I add all 70k records in one batch, or should it need splitting in to different batch?

Thanks in advance...

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Batch Insert
jomy george
October 18, 2011 02:58AM
Re: Batch Insert
Rick James
October 19, 2011 08:39PM


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.