GullFOSS
OpenOffice.org Engineering at Sun
 
Subscribe
Subscribe to RSS Feed RSS Feed
Subscribe to Atom Feed Atom Feed
Bookmark to del.icio.us Bookmark to del.icio.us

Today's Page Hits: 1975

 
Archives
 
« October 2006 »
SunMonTueWedThuFriSat
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
    
       
Today
Links




Flickr Photos
More Flickr photos tagged with openoffice
Locations of visitors to this page
all tags: accessibility apache api aqua architecture automated_tests automation base beta build calc chart code community compiler cws database development directx download draw eis events export extensions features filter framework graphics gsl gsoc gullfoss i18n import impress installation irc iso26300 java l10n localization mac macros netbeans odf odff ooo ooocon ooxml opendocument openoffice.org patch pdf performance plugin podcast porting qa quality quaste release report sdk snapshot software specification spreadsheet staroffice statistics statuspage sun svg testing toolkit tools usability user-experience vba web wiki writer writerfilter xml
« Previous day (Oct 11, 2006) | Main | Next day (Oct 12, 2006) »
Thursday, 12 Oct 2006
Performance Gain of Factor 15 to 40
Eike Rathke

I knew the headline would draw your attention ;-)

I'd love it (and you'd love us) if these numbers were for the entire application suite, but totally unspectacular they're for the import of huge formula loaded MS-Excel documents into Calc, which is nice enough to be delighted anyway.. Down on the floor and back to the facts: when loading a quite big Excel document, I'm referring to 25 MB of size, more than 100 sheets, a million cells and hundredthousand formulas, formula cells unnecessarily broadcasted their initial recalculation state to all dependents. Building up this dirty tree took most of the time and by replacing it with a document wide simple chain mechanism for this case, loading times went down to a fraction. The metrics from two different machines for that document are:

Small one processor system:
model name      : Intel(R) Pentium(R) 4 CPU 1.80GHz
cpu MHz         : 1816.213
cache size      : 256 KB
bogomips        : 3617.58
Mem free        : 386488 kB (or somewhere near that)
old performance : 39:08 minutes
new performance :  2:37 minutes
performance gain: factor 15

Two dual core processors system:
model name      : Dual Core AMD Opteron(tm) Processor 275
cpu MHz         : 2194.038
cache size      : 1024 KB
bogomips        : 4393.64
Mem free        : 3388412 kB
old performance : 27:58 minutes
new performance :  0:43 minutes
performance gain: factor 39

This is from issue 68960, targeted to OOo2.1

[tags: , ]

tags:

Posted by Eike Rathke on 12 Oct 2006  |  PermaLink |  Bookmark to del.icio.us Bookmark to del.icio.us |  Digg this Digg this  |  Comments[2]

Development at a Glance - Weekly Update CW41
Dieter Loeschky



I would like to give an regular weekly update on what is hot in our development teams to make our work more transparent to the whole OpenOffice.org community.



IN FOCUS

OpenFormular

„OpenFormula is the informal name of the OpenDocument formula specification. The OpenFormula draft specification describes how to exchange recalculated formulas between any two applications (primarily spreadsheet programs). Anyone can implement this specification, both proprietary and open source software projects, and it's being developed through the cooperation of a large number of competing implementors.

OpenFormula is designed to let you own your own data, so you can choose which spreadsheet application you want to use, and still exchange data with people who made different choices. As a result, countries can remain sovereign from their suppliers, organizations are no longer entrapped by any particular supplier, data will be accessible far into the future, and anyone can innovate and use the innovations of others.

OpenFormula only covers recalculated formulas (such as those for spreadsheets). For the display of arbitrary mathematical expressions, OpenDocument uses MathML, the standard for displayed mathematical expressions in XML-based documents. MathML and OpenFormula are complementary standards, for example, the OpenFormula specification uses MathML to describe functions.“

Source: The OASIS Office Formula Subcommittee



WEEKLY SCHEDULE

  • ALL TEAMS

    • Started:

      • -

    • Ongoing:

      • OOo 2.1 bug fixing

    • Finished:

      • -

  • CALC
    http://sc.openoffice.org/

    • Started:

      • Enable range selection in new chart

    • Ongoing:

      • ODF formula specification

      • OOo 2.1 patch evaluation

      • Integrate locale data from OOo community

      • Specification for automatic scaling

    • Finished:

      • Use of new chart API for Excel export

      • Clipboard CSV format options

  • CHART
    http://graphics.openoffice.org/chart/chart.html

    • Started:

      • Specification Finalization: Flexible Source Ranges and Toolbar

      • Automatic break for axis labels

    • Ongoing:

      • Milestone 9 development (Beta Version of chart reimplementation)

      • Bugfixes for pie charts

      • Clipboard: Copy/paste whole chart

    • Finished:

      • Bugfixes for pie charts: Layout of pies and donuts with labels

      • Clipboard: Copy inside chart

  • DATABASE
    http://dba.openoffice.org/

    • Started:

      • Allow to start edit of query in SQL view

    • Ongoing:

      • OOo 2.1 bug fixing

    • Finished:

      • Resurrect the a11ysep CWS

      • Separate the BasicManager from the SfxObjectShell

  • IMPRESS, DRAW & GRAPHIC SYSTEM LAYER
    http://graphics.openoffice.org/
    http://gsl.openoffice.org/

    • Started:

      • -

    • Ongoing:

      • Impress view API for components

      • Slideshow z-order for shapes

      • Handling of high score stack traces

      • Further design of an awt tree control API and implemenation

      • UNO API for drawing layer primitives

    • Finished:

      • Multi monitor support for slideshow

  • WRITER, MATH & FRAMEWORK
    http://sw.openoffice.org/
    http://framework.openoffice.org/

    • Started:

      • Framework: DockingWindows in LayoutManager (preparation for usage in extensions)

    • Ongoing:

      • Word Import Filter: Import of Tables

      • Core Development: Design of Table Model supporting all ODF tables and Word tables

      • Linguistic: Integration of component for language guessing

      • Linguistic: Review of API for Grammar Checking

      • Framework: Centralize management of caption bar titles

      • Performance: move legacy filters to binfilter module, finalizing CWS

      • API: Introduce new style services for Text Document

      • MS Interop: Design changes for Numbering/Outlines

    • Finished:

      • -

  • PROGRAMMABILITY
    http://api.openoffice.org/
    http://udk.openoffice.org/
    http://installation.openoffice.org/
    http://util.openoffice.org/
    http://ucb.openoffice.org/

    • Started Tasks:

      • Online Update: draft of new update notification protocol

    • Ongoing Tasks:

      • NetBeans Integration: Component Wizard

      • Extension infrastructure: versioning, extendable help

      • Developer Tools: improvements for Object Inspector

      • Setup: Java GUI installer for OO.o

      • Online update: new progress/download dialog

      • Developers Guide: New chapter for UNO-AWT

      • Setup: Installation of extensions during office setup

      • Extension Infrastructure: Localization Support for Dialog Editor

      • Basic IDE: Support for Database Documents

      • Extensions infrastructure: Online update for extensions, system integration for oxt extensions

    • Finished:

      • API tests for OO.o 2.0.4

  • ODF / XML
    http://xml.openoffice.org/


tags:

Posted by Dieter Loeschky on 12 Oct 2006  |  PermaLink |  Bookmark to del.icio.us Bookmark to del.icio.us |  Digg this Digg this

« Previous day (Oct 11, 2006) | Main | Next day (Oct 12, 2006) » GullFOSS