For the second time in a few weeks I've got a
corrupted database.  Each time the corruption occurs
when trying to insert (via COPY into) data into a
large table and the row count exceeds 100-110M.  Each
time the database terminates and a restart never
allows another connection to the SQL interface.

I've checked and no column is coming close to the 2G
limit as well.  The largest column is approximately
900M.

My question is this:

Would a switch to version five improve my results?  Is
version five more stable w.r.t. large (100M+) table
handling?

This stability issue is rather disappointing because
MonetDB has done so well in all of my other testing. 
Query performance compared to other
(commercial/non-commercial) products was outstanding
for result sets of 5 - 750000 rows.

Also, I wish there were better controls over maximum
RAM usage.


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
MonetDB-users mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/monetdb-users

Reply via email to