Hi all,
We are facing some performance issues for some users.
Some modules are set for shareable edit and contain more than 600 editable sections.
Could that be a performance hit?
In DOORS help it is said: "... Try not to set up editable sections unless you need them. Performance gets poorer as the number of editable sections increases, because each editable section is stored in a separate file in the database... "
Are there any metrics for what should be a reasonable number of sections ?
Thanks for your help,
Pierre
Pierre Pornin - Tue Jun 29 10:25:52 EDT 2010 |
Re: What is the recommanded maximum number of editable sections in a module
llandale - Tue Jun 29 19:09:19 EDT 2010
The number of sections should be driven by how many folks will share the module simultaneously and may try to edit nearby objects; or to which sections they are assigned. If Joe is assigned 3.2.1 and Jane 3.2.2 etc, they you won't need many sections. If Joe is assigned Attrs A and B while Jane assigned C and D, then you will have a section problem as both folks will sometimes want to edit the same object; which encourages many small sections. You want to avoid small sections if the same person will be editing nearby objects, as it will cause her to lock and unlock a lot.
Realistically, setting all level 1, 2, and 3 Headings as Sections is a good default start. Add other sections as needed.
I hear tell that you can 'combine' the module's files back into a single file by opening the module 'Edit' and then saving it. It will then, so I hear, re-fragment at section boundries as those sections are locked. If so, a simple scheduled batch DXL script to edit and combine every week-end sounds reasonable.
|