Difference between revisions of "Performance"

From Apache OpenOffice Wiki
Jump to: navigation, search
(→‎Calc: embed DPL)
(→‎ToDo's: get rid of the ugly and wrong possessive apostrophe; use wiki links instead of http://... to not produce outbound references)
Line 11: Line 11:
 
This page will be cleaned up soon.
 
This page will be cleaned up soon.
  
== ToDo's ==
+
== To-Dos ==
  
Probably a lot - please [http://wiki.services.openoffice.org/wiki/Performance/ToDo%27s continue here].
+
Probably a lot - please [[Performance/To-Dos| continue here]].
  
 
== Work in progress ==
 
== Work in progress ==

Revision as of 21:31, 12 February 2009

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

  • Performance/Startup#Issues
  • Performance - Analysis (Windows) Data
    • File I/O done by OpenOffice.org during startup
    • Measure cold startup time of OpenOffice.org 3.1 and svdem.exe

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)



Impress

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