Performance

From Apache OpenOffice Wiki
Revision as of 10:52, 10 September 2022 by DiGro (talk | contribs) (→‎The performance project)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Performance 170.png
Performance Project

performance.openoffice.org

Quick Navigation

Team

Communication

Activities

About this template


The performance project

This wiki page is the collaboration entry point for the AOo Performance project.

For questions and discussions, please use the new mailing list from the performance project: dev@openoffice.apache.org

When you plan to file an issue with regard to performance, please make sure to add the keyword performance

The official (incubator) project was started February 2009, but there have already been a lot of activities in this area in the past, so some of the information here (especially on the linked wiki pages) might be outdated.

This page will be cleaned up soon.

Deliverables

  • A test system for collecting reproducible and comparable performance data of OpenOffice.org master builds.
  • A test methodology for measuring and comparing performance data of OpenOffice.org master and CWS builds.
  • Lightweight tools that automatically collect performance data and assist developers in identifying performance bottlenecks.
  • Real life test scenarios which will also be reflected in the automatic performance tests.
  • OpenOffice.org startup performance improvements
  • OpenOffice.org ODF load/save performance improvements
  • Performance oriented analysis of OpenOffice.org's framework

Work in progress

Plan

  • To-Dos

Probably a lot - please continue here.

Work

Startup

Writer

Calc

The DPL extension (version 2.3.0) produced a SQL statement which lead to a Database error.
The reason may be an internal error of DPL or an error which you made,
especially when using DPL options like titleregexp.
Query text is:
SELECT DISTINCT `page`.page_namespace AS page_namespace,`page`.page_title AS page_title,`page`.page_id AS page_id, rev_user, rev_user_text, rev_comment, rev_timestamp FROM `revision` AS rev, `page` INNER JOIN `categorylinks` AS cl0 ON `page`.page_id=cl0.cl_from AND (cl0.cl_to='Calc') INNER JOIN `categorylinks` AS cl1 ON `page`.page_id=cl1.cl_from AND (cl1.cl_to='InProgress') INNER JOIN `categorylinks` AS cl2 ON `page`.page_id=cl2.cl_from AND (cl2.cl_to='Performance') WHERE 1=1 AND NOT (`page`.page_title LIKE 'Calc/InProgress/Performance') AND `page`.page_is_redirect=0 AND `page`.page_id=rev.rev_page AND rev.rev_timestamp=( SELECT MAX(rev_aux.rev_timestamp) FROM `revision` AS rev_aux WHERE rev_aux.rev_page=rev.rev_page ) ORDER BY rev_timestamp DESC LIMIT 500 OFFSET 0

Error message is:
Unknown column 'rev_user' in 'field list' (127.0.0.1)



For finished work see Calc/Done/Performance.

Impress

Base

Load/Save General (Non Application Specific Tasks)

Achievement

Performance Status

User Experience Index (UEI)

UEI and Case Documents

Distribution and Tracing

Analysis of Performance

Hotspots

Test results for different versions

Tooling and TC

Helpful Tooling and Resources

Test Environment

Popular reference configuration(use similar env on Hamburg and Beijing)

CPU:    Core2 Duo 1.5~2G
Memory: 512M
OS:     WindowsXP HOME

Test & Tuning Tools

Benchmarks & Description

If you have some benchmarks, share them here!

Integrated improvements

Other Resource

This Wiki page should become the ultimate authority on performance issues. Meanwhile, here are links to performance informationat other places

Personal tools