On Sun, Apr 20, 2008 at 05:43:36AM -0700, mobigital1 wrote:
this should be the same:
table columns:
col1..col16 : smallint null col17..col160: real null
select col1, col2, sum(col17), sum(col18), sum(col19) from thetable group by col1, col2;
should return a total of about 8000 rows, each row would be an aggregation from about 50,000 rows from "thetable".
I repeated this experiment using a script to generate random small numbers etc. The loading took about 12 hours (on my desktop (8GB memory)). The query about 13 minutes. I didn't find any problem.
Niels
-- View this message in context: http://www.nabble.com/mserver5-process-locked-unkillable-tp16789362p16790887... Sent from the monetdb-users mailing list archive at Nabble.com.
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao... _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users