MySQL Forums
Forum List  »  Newbie

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...

Options: ReplyQuote

Written By
Batch Insert
October 18, 2011 02:58AM
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.