Tuesday, 7 of September of 2010

DOORS Database Architecture Analysis – Part I: Performance Issues

DOORS Performance – How to make it faster

Over the last few years we have gained a great amount of tips and tricks to help you improve your performance when working with DOORS. From our experience with working on different implementations of DOORS in different environments we’ve learned that there are some basic guidelines that if followed can improve your work with the tool.    These guidelines can help you improve your user experience, allow your organization to manage larger modules and improve the usability of the tool.

The beauty of it is that these guidelines can be adopted both by new or existing projects. Even if you have already started working with the tool it’s not too late to make these improvements.

Guidelines for working with attributes:

  1. Prefer String attributes over Text attributes
  2. Reduce the number of attributes in modules
  3. Where possible prefer to use DXL columns as opposed to DXL attributes.
  4. Try to use Text objects as opposed to Heading Objects, as it makes scrolling very slow.
  5. Default views – Affects the time it takes to open a module. Therefore, the recommendation is to:
    1. Use ‘light’ views as default views.
    2. Reduce number of attributes in default view (Specially: DXL attributes and Text attributes)
    3. Prefer avoiding DXL column in default view.
    4. Prefer hiding the Explorer from the default view.
  6. Shareable edit – Large number of shared objects in a module affect performance. If used, try to build the shareable edit for the highest level of hierarchy that will still provide value.
  7. Pack History into Baseline – it is recommended that every once in a while baseline a module to move all the history to the baseline.
  8. Purge “soft-deleted” objects – After a while the module might have a large amount of object that were “soft-deleted”. Therefore, if the objects are no longer needed purge the objects in the module.

Guidelines for DXL code:

  1. Link structure
    1. Reduce number of link modules. Make sure you are working with a defined number of link modules.
    2. Verify ‘Link Enforcement’

A presentation on this topic was given in Manageware’s DOORS user forum. Here is a link to the presentation:


Leave a comment

You need to be loged to make a comment