Hi,
I am working on a Windows XP SP2 32bit with MonetDB v5.2.2 kernel v1.20.0
I have built a java program to upload data from an Oracle Database Table
with 6milion rows.
After about 4milion of rows loaded the performance decreases dramatically.
I have tried to use other way, which is generating all insert statements to
a file and then using mclient to execute all the insert statements.
Slower that the java option because the autocommit=on and parsing of each
statement, but the result is the same.
After about 4milion of rows loaded the performance decreases dramatically.
Can someone give an explanation for this behavior?
Thanks,
Paulo Jorge Dias
--
View this message in context: http://www.nabble.com/Slow-Data-Load-tf4929292.html#a14108678
Sent from the monetdb-users mailing list archive at Nabble.com.
I tried running the SQLAlchemy ORM testsuite. The first time it ran
for a while and then mserver segfaulted. (It also grew to using
700+Megs of memory. Am assumming this is a monetdb issue, since after
each test the tables are usually dropped). The server now has issues.
It appears to start fine:
# MonetDB server v5.2.3, based on kernel v1.20.1
# Serving database 'demo'
# Compiled for i686-pc-linux-gnu/32bit with 32bit OIDs dynamically linked
# Copyright (c) 1993-2007 CWI, all rights reserved
# Visit http://monetdb.cwi.nl/ for further information
#warning: please don't forget to set your vault key!
#(see /root/MonetDB/etc/monetdb5.conf)
# Listening for connection requests on mapi:monetdb://127.0.0.1:50000/
# MonetDB/SQL module v2.20.3 loaded
When I try to connect with the command line client it complains repeatedly:
!ERROR: BUNdelete: access denied to tmp_537, aborting.
!ERROR: BUNdelete: access denied to tmp_537, aborting.
....