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
> Shaw
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, 201
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 wrote:
> Greetings everyone.
>
> I am in a situation where I need to do parallel inserts into MySQL database
> from inside my Perl program.
On 12/13/2010 21:32, Andy 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
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 no