[
https://issues.apache.org/jira/browse/DERBY-4363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12753600#action_12753600
]
Knut Anders Hatlen commented on DERBY-4363:
-------------------------------------------
I've only run the tests in one configuration (-load group_by -load_opts
numGroupingCols=2,numGroups1=10,numGroups2=100), but my runs confirm what
you're seeing. I had a quick look at some profiling results, but nothing jumped
at me. The runs with the DERBY-3002 patch did seem to spend more time copying
values, though (ValueRow.getClone() and SQLInteger.getClone() in particular).
Not sure if that helps, but I thought I'd mention it.
> 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: benchmark.sh, bmTrunk.out, bmWithPatch.out,
> multiColumnBenchmark.diff, 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.
