sir/mam, I unable to read the contents therefore neither get my query's answer nor able to open it .... . . .. do send way to open it . On Fri, Mar 29, 2013 at 4:30 PM, wrote:

Send developers-list mailing list submissions to developers-list@monetdb.org

To subscribe or unsubscribe via the World Wide Web, visit http://mail.monetdb.org/mailman/listinfo/developers-list or, via email, send a message with subject or body 'help' to developers-list-request@monetdb.org

You can reach the person managing the list at developers-list-owner@monetdb.org

When replying, please edit your Subject line so it is more specific than "Re: Contents of developers-list digest..."

Today's Topics:

1. Re: how to speed up the loading of data into a table (Niels Nes) 2. Re: how to speed up the loading of data into a table (Niels Nes) 3. Re: how to speed up the loading of data into a table (Stefan Manegold)

----------------------------------------------------------------------

Message: 1 Date: Thu, 28 Mar 2013 20:17:08 +0100 From: Niels Nes To: "Communication channel for developers of the MonetDB suite." Subject: Re: how to speed up the loading of data into a table Message-ID: <20130328191708.GB13470@niels.cwi.nl> Content-Type: text/plain; charset="utf-8"

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@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