how to speed up the loading of data into a table

Niels Nes Niels.Nes at cwi.nl
Thu Mar 28 20:17:08 CET 2013


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
> 
> ?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?
			 typo ?

			 Niels
> 
> cordialy.

> _______________________________________________
> developers-list mailing list
> developers-list at 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 at sip.cwi.nl
url: http://www.cwi.nl/~niels   e-mail: Niels.Nes at cwi.nl
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: not available
URL: <http://www.monetdb.org/pipermail/developers-list/attachments/20130328/18cdf937/attachment.sig>


More information about the developers-list mailing list