how to speed up the loading of data into a table

Bouslah Ahmed a.bouslah at yahoo.fr
Thu Mar 28 19:41:08 CET 2013


Good afternoon,

I have 2 questions :
- 1st question 
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?

2nd question :
how inner joins are made in MongoDB?

cordialy.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.monetdb.org/pipermail/developers-list/attachments/20130328/95b59c21/attachment.html>


More information about the developers-list mailing list