MySQL Forums :: Newbie :: Batch Insert


Advanced Search

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


Subject Written By Posted
Batch Insert jomy george 10/18/2011 02:58AM
Re: Batch Insert Rick James 10/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.