db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4363) Add simple benchmark for measuring GROUP BY performance
Date Mon, 31 Aug 2009 09:07:32 GMT

    [ https://issues.apache.org/jira/browse/DERBY-4363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12749431#action_12749431

Knut Anders Hatlen commented on DERBY-4363:

Hi Bryan,

Thanks for writing the test. It looks good to me, and I think it will be helpful in evaluating
whether DERBY-3002 affects plain GROUP BY statements in any way.

Currently, the test uses a mix of three different statements with different characteristics.
This means that the reported results only show the average, and some effects may be hidden
if the performance of one of the statements is improved whereas another one performs worse.
Perhaps we should have an option to run with just one of the statements?

Do you think it would add value to have a test case with multiple GROUP BY columns?

> Add simple benchmark for measuring GROUP BY performance
> -------------------------------------------------------
>                 Key: DERBY-4363
>                 URL: https://issues.apache.org/jira/browse/DERBY-4363
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Test, Tools
>            Reporter: Bryan Pendleton
>            Assignee: Bryan Pendleton
>            Priority: Minor
>         Attachments: simpleBenchmark.diff
> As part of ROLLUP implementation (DERBY-3002), it will be helpful to be able to measure
the performance of GROUP BY.
> Using the o.a.dT.perf.clients framework, this sub-task proposes to add a GroupByClient
to the performance runner
> library; the GroupByClient will run GROUP BY statements against the Wisconsin benchmark

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message