On Thu, Mar 28, 2013 at 06:41:08PM +0000, Bouslah Ahmed wrote:
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 Did you try loading it directly on the server, ie not using the 'STDIN' and < D:\\etc
Niels
?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.
_______________________________________________ developers-list mailing list developers-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/developers-list
-- Niels Nes, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl