Performance

From Apache OpenOffice Wiki
Revision as of 14:22, 31 March 2009 by Andrewz (talk | contribs) (+1 benchmark)
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 OOo Performance project.

For questions and discussions, please use the new mailing list from the performance project: dev@performance.openoffice.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.

To-Dos

Probably a lot - please continue here.

Work in progress

Startup

Writer

  • What's going on in Writer load/save performance see here

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)

User Experience Index (UEI)

UEI and Case Documents

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!

Performance Test Results Distribution

Test results for different versions

Integrated improvements

Other Pages

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

Personal tools