[MonetDB-users] Problem with running TPC-H query No.5
Niels.Nes at cwi.nl
Mon Dec 17 20:55:57 CET 2007
On Mon, Dec 17, 2007 at 11:56:14AM +0000, Konstantinos Krikellas wrote:
> I am using MonetDB for benchmarking on the TPC-H workload. I
> have successfully run queries 1, 3 and 10. However, when I try
> to run query 5:
For this query to be quick you need all keys, ie primary and foreign.
Does you tpch-h schema include those?
> sum(l_extendedprice * (1 - l_discount)) as revenue
> c_custkey = o_custkey
> and l_orderkey = o_orderkey
> and l_suppkey = s_suppkey
> and c_nationkey = s_nationkey
> and s_nationkey = n_nationkey
> and n_regionkey = r_regionkey
> and r_name = 'ASIA'
> and o_orderdate >= date '1994-01-01'
> and o_orderdate < date '1994-01-01' + interval '1'
> group by
> order by
> revenue desc;
> it takes about two (2) hours to evaluate it. It is obvious that
> the query cannot be executed inside the main memory, so the
> system thrashes through paging. Still, this behaviour does not
> appear for the rest of the queries, as they are computed within
> one or two seconds. In all cases, the results are correct.
> The specifications of my system are:
> Processor: Intel Core 2 Duo @ 1.86 Mhz
> RAM: 2 Gb
> Operating System: Linux Ubuntu Gutsy 7.10
> MonetDB version: Mserver5 (recently downloaded from your site).
> Can you give me some indications about why this query takes too
> long and how can I bypass this response delay?
> SF.Net email is sponsored by:
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services
> for just about anything Open Source.
> MonetDB-users mailing list
> MonetDB-users at lists.sourceforge.net
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 at cwi.nl
More information about the users-list