27 Mar
2013
27 Mar
'13
6:44 p.m.
Good afternoon, 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? cordialy.
4242
Age (days ago)
4242
Last active (days ago)
0 comments
1 participants
participants (1)
-
Bouslah Ahmed