, CT 06032
860.674.8796 / FAX: 860.674.8341
E-mail: je...@gii.co.jp
Web site: www.the-infoshop.com
-Original Message-
From: mos [mailto:mo...@fastmail.fm]
Sent: Monday, January 03, 2011 3:25 PM
To: Jerry Schwartz; mysql@lists.mysql.com
Subject: RE: This just seems to slow
Jerry,
Try
: 860.674.8341
E-mail: je...@gii.co.jp
Web site: www.the-infoshop.com
-Original Message-
From: mos [mailto:mo...@fastmail.fm]
Sent: Tuesday, January 04, 2011 12:26 PM
To: Jerry Schwartz; 'mos'; mysql@lists.mysql.com
Subject: RE: This just seems to slow
At 05:08 PM 1/3/2011, Jerry Schwartz wrote
Subject: Re: This just seems to slow
Jerry,
Use Load Data Infile when loading a lot of data. Whoever is giving
you the data should be able to dump it to a CSV file. Your imports will be
much faster.
Mike
At 07:51 PM 1/2/2011, you wrote:
I'm trying to load data into a simple table
-Original Message-
From: Wagner Bianchi [mailto:wagnerbianch...@gmail.com]
Sent: Monday, January 03, 2011 4:42 AM
To: Daevid Vincent
Cc: mysql@lists.mysql.com; mos
Subject: Re: This just seems to slow
Multiple line insert is the better choice...it will be organized in
transaction blocks
-Original Message-
From: Daevid Vincent [mailto:dae...@daevid.com]
Sent: Sunday, January 02, 2011 11:49 PM
To: mysql@lists.mysql.com
Cc: 'mos'
Subject: RE: This just seems to slow
Another option would be to mangle your insert statement with some other
language like PHP, Python, Ruby, etc
On 1/3/2011 10:41, Jerry Schwartz wrote:
-Original Message-
From: Daevid Vincent [mailto:dae...@daevid.com]
Sent: Sunday, January 02, 2011 11:49 PM
...
Also delete your INDEX / KEYs and add them at the very end instead.
[JS] Wouldn't it take as long to build the indices? I guess it
@lists.mysql.com
Subject: Re: This just seems to slow
Jerry,
Use Load Data Infile when loading a lot of data. Whoever is giving
you the data should be able to dump it to a CSV file. Your imports will be
much faster.
Mike
At 07:51 PM 1/2/2011, you wrote:
I'm trying to load data into a simple
the secondary indexes on the table
will also help a lot.
-Original Message-
From: Jerry Schwartz [mailto:je...@gii.co.jp]
Sent: Monday, January 03, 2011 7:56 AM
To: 'mos'; mysql@lists.mysql.com
Subject: RE: This just seems to slow
Okay, I have a confession to make: I have never gotten Load
-Original Message-
From: Gavin Towey [mailto:gto...@ffn.com]
Sent: Monday, January 03, 2011 1:47 PM
To: Jerry Schwartz; 'mos'; mysql@lists.mysql.com
Subject: RE: This just seems to slow
I much prefer LOAD DATA INFILE to mysqlimport. The issue looks like you have
a
file with two columns
-Original Message-
From: mos [mailto:mo...@fastmail.fm]
Sent: Sunday, January 02, 2011 11:42 PM
To: mysql@lists.mysql.com
Subject: Re: This just seems to slow
Jerry,
Use Load Data Infile when loading a lot of data. Whoever is giving
you the data should be able to dump it to a CSV
, 2011 3:25 PM
To: Jerry Schwartz; mysql@lists.mysql.com
Subject: RE: This just seems to slow
Jerry,
Try this:
mysqlimport -uusername -ppassword --verbose --debug-info --delete
--columns=`dm_history_dm_id`,`DM_History_Customer_ID` --local
--fields-terminated-by=, --fields-optionally-enclosed
Jerry,
Use Load Data Infile when loading a lot of data. Whoever is giving
you the data should be able to dump it to a CSV file. Your imports will be
much faster.
Mike
At 07:51 PM 1/2/2011, you wrote:
I'm trying to load data into a simple table, and it is taking many hours (and
still
),
VALUES (13071, 299521),
...
That will radically speed up the inserts.
Also delete your INDEX / KEYs and add them at the very end instead.
-Original Message-
From: mos [mailto:mo...@fastmail.fm]
Sent: Sunday, January 02, 2011 8:42 PM
To: mysql@lists.mysql.com
Subject: Re: This just seems
13 matches
Mail list logo