Re: Question about : LOAD DATA

Stefan Manegold Stefan.Manegold at cwi.nl
Thu Mar 28 00:44:22 CET 2013


Please see my answer I sent to your identical question yesterday.

Stefan

--
| Stefan.Manegold @ CWI.nl | DB Architectures (INS1) |
| http://CWI.nl/~manegold/ | Science Park 123 (L321) |
| Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam  (NL) |


----- Reply message -----
From: "Bouslah Ahmed" <a.bouslah at yahoo.fr>
To: "developers-list at monetdb.org" <developers-list at monetdb.org>
Subject: Question about : LOAD DATA
Date: Wed, Mar 27, 2013 19:44




Good afternoon,

I have a csv file with 300000000 million lines.

when I load it in a MonetDB table, it takes more than 16 hours, whereas in Oracle it only takes 15 minutes. Where is the problem?
I use mclient as follows :?
mclient -u user1 -d demo -ims -s " COPY 300000009 RECORDS INTO LINEORDER FROM STDIN USING DELIMITERS '|','\n'" - < D:\SSB\LINEORDER.tbl


 for information I use :

MonetDB5
Windows
Memory : 16 Go
There are two constraints : primary key and foreign key on the table prior to loading data?

cordialy.


More information about the developers-list mailing list