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 Thu, 10 Sep 2009 13:02:57 GMT

    [ 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.


Mime
View raw message