You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Dag H. Wanvik" <da...@oracle.com> on 2011/03/01 09:40:03 UTC
Re: [jira] Closed: (DERBY-5067) Performance regression tests should populate tables before creating indexes
"Knut Anders Hatlen (JIRA)" <ji...@apache.org> writes:
> [
> https://issues.apache.org/jira/browse/DERBY-5067?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
> ]
>
> Knut Anders Hatlen closed DERBY-5067.
Jeg får disse rapportene, men det er tungt å lese dem (rar
linjebrekking, ingen grafikk).. hva gjør du får å raskt se hva som er
trenden?
Dag
> -------------------------------------
>
>
> The results seem to have stabilized at the same level as before the
> enabling of istat. Closing the issue.
>
>> Performance regression tests should populate tables before creating indexes
>> ---------------------------------------------------------------------------
>>
>> Key: DERBY-5067
>> URL: https://issues.apache.org/jira/browse/DERBY-5067
>> Project: Derby
>> Issue Type: Improvement
>> Components: Test
>> Affects Versions: 10.8.0.0
>> Reporter: Knut Anders Hatlen
>> Assignee: Knut Anders Hatlen
>> Fix For: 10.8.0.0
>>
>> Attachments: pk.diff, select.png
>>
>>
>> I've noticed that the results from some of the performance regression tests have become more unstable the last two weeks. See for example here: http://home.online.no/~olmsan/derby/perf/select_30d.html
>> I suspect it's because the automatic index statistics thread is running (the instability started at about the same time as it was enabled). We should make the test clients create indexes after the tables have been populated so that the statistics will be up to date and no work in the background is needed.
Re: [jira] Closed: (DERBY-5067) Performance regression tests should populate tables before creating indexes
Posted by "Dag H. Wanvik" <da...@oracle.com>.
dag.wanvik@oracle.com (Dag H. Wanvik) writes:
> Jeg får disse rapportene, men det er tungt å lese dem (rar
> linjebrekking, ingen grafikk).. hva gjør du får å raskt se hva som er
> trenden?
Oops, sorry about that Norwegian, the mail was intended for Knut, I just
asked how one is able to easily discern trends in the raw data, the
reports I see are just columnar data, no graphs.
Dag
Re: [jira] Closed: (DERBY-5067) Performance regression tests should populate tables before creating indexes
Posted by "Dag H. Wanvik" <da...@oracle.com>.
dag.wanvik@oracle.com (Dag H. Wanvik) writes:
> Jeg får disse rapportene, men det er tungt å lese dem (rar
> linjebrekking, ingen grafikk).. hva gjør du får å raskt se hva som er
> trenden?
Oops, sorry about that Norwegian, the mail was intended for Knut, I just
asked how one is able to easily discern trends in the raw data, the
reports I see are just columnar data, no graphs.
Dag