Hi. MySQL do the sql parse in the single way, just one thread. So if there are parallel insert statement, it will not faster than before. David Yeung, In China, Beijing. My First Blog:http://yueliangdao0608.cublog.cn My Second Blog:http://yueliangdao0608.blog.51cto.com
2010/12/17 Andy <listan...@gmail.com> > Shawn/Krishna, > > Thank you. I will try this. > > -Andy > > > On Tue, Dec 14, 2010 at 8:13 AM, Krishna Chandra Prajapati < > prajapat...@gmail.com> wrote: > > > Hi Andy, > > > > I agree, prefer LOAD DATA INFILE... command for bulk loading. It is 30% > > faster than normal inserts. > > > > Krishna > > > > > > On Tue, Dec 14, 2010 at 8:02 AM, Andy <listan...@gmail.com> wrote: > > > >> Greetings everyone. > >> > >> I am in a situation where I need to do parallel inserts into MySQL > >> database > >> from inside my Perl program. Basically, I have several million records > to > >> insert into the database, and hence I would rather do them in parallel > >> than > >> doing them one at a time. I looked around but did not find any > information > >> on doing this. Does MySQL not support parallel reads/writes? > >> > >> Thanks in advance. > >> > >> Andy > >> > > > > >
