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, developers-list-request@monetdb.orgwrote:
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:
- Re: how to speed up the loading of data into a table (Niels Nes)
- Re: how to speed up the loading of data into a table (Niels Nes)
- 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 Niels.Nes@cwi.nl To: "Communication channel for developers of the MonetDB suite." developers-list@monetdb.org 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 ? Nielscordialy.
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