IBM Support

PM18401: performance of export to Excel 300% worse between 8.3 and 9.2.x

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Problem
    Exporting large modules to Excel performs poorly in 9.2.x
    compared to 8.3. The users data which they are not able to
    provide shows a decrease in performance of 800%. With the data
    we created and attached to the case the performance is 300%
    worse. The module in question has 17000 objects and a few user
    defined attrs.
    
    To Reproduce
    With 9204 do the following
    
    - restore the attached module
    - open the module and switch to 'view 1'
    - export to Excel (choose to display both obj head/text for the
    main column)
    - time how long it takes
    
    Now try the same with 8.3 and compare results. MIne are as
    follows:
    
    8.3 - 3 mins
    9204 - 10 mins
    
    
    Possible Workarounds
    use export to csv? or continue to wait.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Exporting large modules to Excel performs poorly in 9.2.x
    compared to 8.3. Specific data can show a decrease in
    performance up to 800%.
    

Problem conclusion

  • The code has been changed so that the performance is now
    comparable to DOOR 8.3
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM18401

  • Reported component name

    TLOGIC DOORS

  • Reported component ID

    5724V61DR

  • Reported release

    920

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-07-14

  • Closed date

    2010-09-17

  • Last modified date

    2010-09-17

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    TLOGIC DOORS

  • Fixed component ID

    5724V61DR

Applicable component levels

  • R920 PSN

       UP



Document information

More support for: Rational DOORS

Software version: 9.2

Reference #: PM18401

Modified date: 17 September 2010