
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