22 Feb
2008
22 Feb
'08
3:23 p.m.
I am trying to load about 500M rows into a table with about 160 columns:
column types: 7 columns of type "int" 2 columns of type "varchar(20)" 6 columns of type "varchar(10)" 1 columns of type "varchar(15)" 144 columns of type "real"
on a system with 16 GB RAM , 64 bit windows server 2003 SP2.
it takes some 20 hours to load the 100M rows, but when I reach that boundary, the server seems to crash and database becomes corrupt so that about 95M rows have 0 in numeric columns, blanks in varchars. The remaining 5M rows have real data.
does anyone have any suggestions on what can be done to make it possible to load this data?
--
View this message in context: http://www.nabble.com/COPY-TO-corrupting-data-tp15634267p15634267.html
Sent from the monetdb-users mailing list archive at Nabble.com.