Re: [MonetDB-users] Profiling queries

On Wed, Dec 05, 2007 at 01:09:48AM -0700, m h wrote:

On Dec 5, 2007 12:46 AM, Niels Nes wrote:

...

All of the groupby columns are varchar (except the last bigint). I'm just guessing but do you see high numbers in your trace for the group.* calls? (The numbers are listed a before the statement being executed).

Again, I'll look at this after rest, but how do you get around group by when your aggregating data? I'm just looking where the cost come from. Maybe our groupby on strings isn't strong enough. Usually grouping on group by attributes with low ordinality (low number of different values in the type) is better.

Niels

------------------------------------------------------------------------- SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl