[MonetDB-users] Very slow group by sql query

Arjen van der Meijden acmmailing at tweakers.net
Mon Oct 22 07:35:33 CEST 2007


On 21-10-2007 16:41 Niels Nes wrote:
> Could your try with the to be released code, ie run
> 
> monetdb-install.sh --enable-sql --enable-optimize --nightly=stable
> 
> I get slightly different code, which looks faster.

Its equally slow, and the fast query seems to be ten times slower now (7 
secs vs 0.7).

I've attached the new traces. If you like, I can probably get you a copy 
of the data off-list, it should be repeatable with only one day of data, 
which is 11MB bzip2'ed.

Best regards,

Arjen
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: trace52-fast-group-by.txt
URL: <http://www.monetdb.org/pipermail/users-list/attachments/20071022/5ccd696e/attachment.txt>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: trace52-slow-group-by.txt
URL: <http://www.monetdb.org/pipermail/users-list/attachments/20071022/5ccd696e/attachment-0001.txt>


More information about the users-list mailing list