RE: This just seems to slow

2011-01-04 Thread Jerry Schwartz
: 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

RE: This just seems to slow

2011-01-04 Thread mos
Global Information Incorporated 195 Farmington Ave. Farmington, 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 Schwart

RE: This just seems to slow

2011-01-03 Thread Jerry Schwartz
gt;Sent: Monday, January 03, 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_I

RE: This just seems to slow

2011-01-03 Thread mos
n Ave. Farmington, 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: Sunday, January 02, 2011 11:42 PM >To: mysql@lists.mysql.com >Subject: Re: This just seems to sl

RE: This just seems to slow

2011-01-03 Thread Jerry Schwartz
>-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 l

RE: This just seems to slow

2011-01-03 Thread Gavin Towey
nough to contain 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

RE: This just seems to slow

2011-01-03 Thread Jerry Schwartz
os [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

Re: This just seems to slow

2011-01-03 Thread Shawn Green (MySQL)
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 p

RE: This just seems to slow

2011-01-03 Thread Jerry Schwartz
>-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 som

RE: This just seems to slow

2011-01-03 Thread Jerry Schwartz
>-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 o

Re: This just seems to slow

2011-01-03 Thread Wagner Bianchi
, January 02, 2011 8: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 file. Your imports will be > much faster. &

RE: This just seems to slow

2011-01-02 Thread Daevid Vincent
), 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

Re: This just seems to slow

2011-01-02 Thread mos
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