Question

Stefan Manegold Stefan.Manegold at cwi.nl
Tue Mar 26 23:02:19 CET 2013


Hi,

Which version of MonetDB are you using?

Which OS are you using?

How wide is your table?

How much memory does your machine have?

Are there any constraints defined on your table prior to loading data?

Did/could you try loading directly from file on the server side (requires to use default admin user "monetdb"),
as opposed to from STDIN, i.e., passing all data through mclient?

Stefan

----- Original Message -----
> 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
> 
> 
> cordially.
> 
> _______________________________________________
> developers-list mailing list
> developers-list at monetdb.org
> http://mail.monetdb.org/mailman/listinfo/developers-list
> 

-- 
| Stefan.Manegold at CWI.nl | DB Architectures   (DA) |
| www.CWI.nl/~manegold/  | Science Park 123 (L321) |
| +31 (0)20 592-4212     | 1098 XG Amsterdam  (NL) |




More information about the developers-list mailing list