[
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 database.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
