Hi Stefan.
Thanks again for aswering so quickly. I had intented to use it on user machines and so I'm stuck to Windows XP 32-bit.
It crashes and closes the server. Usually when I restart the server after the crash it shows messages about the memory problem but it's able to start. But sometimes it would not start anymore and I had to reinstall the server, since I don't know what I could do to make it start again.
Regards, Luis Fernando
________________________________ De: Stefan Manegold Stefan.Manegold@cwi.nl Para: Communication channel for MonetDB users monetdb-users@lists.sourceforge.net Enviadas: Sexta-feira, 25 de Junho de 2010 18:20:30 Assunto: Re: [MonetDB-users] Res: MonetDB aborts when importing over 10 million rows
Hi Luis,
on a 32-bit system, MonetDB is limited to database of at most 4 GB; on Windows, the limit is usually at most 3 GB or even only 2 GB, as Windows does not allow larger processes on a 32-bit system; see also http://zone.ni.com/reference/en-XX/help/371361D-01/lvhowto/enable_lrg_ad_awa...
In your case, with 8 files (years) of >300 MB you have >2.4 GB of raw data, and I'm afraid you will not be able to load this amount into MonetDB on a 32-bit Windows system; surely not in the dfault configuration that does not allow processes to grow beyond 2 GB, but evenn if you configure it to allow 3 GB (cf., http://zone.ni.com/reference/en-XX/help/371361D-01/lvhowto/enable_lrg_ad_awa...) it might not work.
To load all the data into MonetDB, you'd need to consider a 64-bit system (and 64-bit MonetDB).
BTW, does the server actually crash, or does it "merely" report an error, aborting the load, but the server keeps running?
Stefan orge.net/lists/listinfo/monetdb-users