Module opening is very very slow

All,

What are possible way to reduce the opening time for the modules?

1. Our modules are not big one. It contain only 1700 objetcs.
2. Few tables and OLE's.
3. We are regularly baselining it.
4. Module is setup in sharable edit mode Level 2.

Not sure why it takes such a long time, whether you belive it or not... My user comment is: "Speed of opening a document is a big issue, like I need more than a hour to open the MAP list module. "

Did any one facing this issue? Please share with me some of the best practices..

Thanks,
Muruga
SystemAdmin - Thu Sep 17 07:34:03 EDT 2009

Re: Module opening is very very slow
mcnairk - Thu Sep 17 08:05:14 EDT 2009

Questions/suggestions that spring to mind are:
  • What is the default view; does it have any layout DXL? Change to the standard view.
  • Do you have any triggers set? Delete them.
  • Which version of DOORS do you have?

Ken.

Re: Module opening is very very slow
SystemAdmin - Thu Sep 17 08:15:19 EDT 2009

mcnairk - Thu Sep 17 08:05:14 EDT 2009
Questions/suggestions that spring to mind are:

  • What is the default view; does it have any layout DXL? Change to the standard view.
  • Do you have any triggers set? Delete them.
  • Which version of DOORS do you have?

Ken.

Hello Thanks for your response....

1. What is the default view; does it have any layout DXL? Change to the standard view.
Default view is not the standard view. Yes, Only one layout dxl in the module.

2. Do you have any triggers set? Delete them.
No triggers

3. Which version of DOORS do you have?
DOORS 8.3

Regards,
Muruga

Re: Module opening is very very slow
SystemAdmin - Thu Sep 17 08:54:44 EDT 2009

Some possibilities if the module opens slowly for all users:

  • Majority of the objects in the module are soft-deleted
  • Default view has attribute/layout DXL columns that are computationally expensive or that require the loading of other modules
  • Module contains an excessive number of links
  • Module contains excessive history (perhaps module needs to be baselined?)
  • Trigger scripts that run when the module is opened
  • Module contains an excessive number of views

Some possibilities if the module opens slowly only for some users:

  • Those users have a user-defined default view that loads slowly
  • Those users are running the DOORS client on a computer with a slow/unreliable connection to the DOORS database server
One way to investigate these possibilities is to archive/restore the module and then perform various clean-up operations on the restore module and test module opening performance after each change. Possible changes include:
  • purge soft-deleted objects
  • baseline module
  • delete unnecessary views
  • reduce the number of links, etc

Re: Module opening is very very slow
dpechacek - Thu Sep 17 10:10:32 EDT 2009

How many sections are there? If you have a lot of sections (from setting up shared edit) it can slow down module load times due to having to get locks on all those files (since shared edit splits the module into individual files).

1700 objects isn't much but if you have 500 sections in there, that would contribute to slow loading times.

AAI Services, Textron
dpechacek@sc-aaicorp.com
David.Pechacek@gmail.com

Re: Module opening is very very slow
llandale - Thu Sep 17 16:38:47 EDT 2009

The following may help in determining the problem.

string    NameMod = "Attr-LayoutDXL Errors" // Put module name here
Module  mod = module(item NameMod)
//ModName_      mn = module(NameMod)
if (!null mod and confirm("Close module?")) close(mod)
 
bool  Visible  = confirm("Open module Visibly?")
bool  DefView  = confirm("[Confirm] to use Default view; [Cancel] for standard view")
 
noError()
int     TimeStart = intOf(today)
if (confirm("[Confirm] to open Read; [Cancel] to open Shared"))
     read (NameMod, Visible, DefView)
else share(NameMod, Visible, true, DefView)
 
infoBox("open time = " (intOf(today) - TimeStart) " seconds.")
lastError()

 


If it opens 10 times faster invisible than visible, or the Standard view is much faster than the Default view, then you probably have some layout in the loaded view. The biggest culprit will be a layout that opens up linked partners, gathers info, then closes the module; thus the other modules are opened/closed several times.

If it opens much faster Shared than Read then you probably cannot do much about that, but its some sort of too-many-sections issues.

If one user on a PC is slow and another fast, then that user probably has a user-specific default view with lots of layout.

 

 

 

  • Louie

 

 

Re: Module opening is very very slow
SystemAdmin - Fri Sep 18 00:36:35 EDT 2009

dpechacek - Thu Sep 17 10:10:32 EDT 2009
How many sections are there? If you have a lot of sections (from setting up shared edit) it can slow down module load times due to having to get locks on all those files (since shared edit splits the module into individual files).

1700 objects isn't much but if you have 500 sections in there, that would contribute to slow loading times.

AAI Services, Textron
dpechacek@sc-aaicorp.com
David.Pechacek@gmail.com

Thanks,

I clicked on Setup for sharing level 2 -> there are 120 sections created.

Can we remove the sharable edit setup? What this level's talk about?

If I setup module in a sharable edit @ Level 2, means Users can lock only level 2 objects???

Correct me If I am wrong, My understanding is If i setup a module in a sharable edit mode, It's basically un-inherit the access from Parent, So that facility provides the users to lock the objects?

So, In future.. I we added any new objects.. instaed of setting up the module once again in a sharable edit mode & creating new sections again, We can just remove the inherit access from parent...

Please advice..

Regards,
Muruga

Re: Module opening is very very slow
SystemAdmin - Fri Sep 18 00:51:13 EDT 2009

llandale - Thu Sep 17 16:38:47 EDT 2009

The following may help in determining the problem.

string    NameMod = "Attr-LayoutDXL Errors" // Put module name here
Module  mod = module(item NameMod)
//ModName_      mn = module(NameMod)
if (!null mod and confirm("Close module?")) close(mod)
 
bool  Visible  = confirm("Open module Visibly?")
bool  DefView  = confirm("[Confirm] to use Default view; [Cancel] for standard view")
 
noError()
int     TimeStart = intOf(today)
if (confirm("[Confirm] to open Read; [Cancel] to open Shared"))
     read (NameMod, Visible, DefView)
else share(NameMod, Visible, true, DefView)
 
infoBox("open time = " (intOf(today) - TimeStart) " seconds.")
lastError()

 


If it opens 10 times faster invisible than visible, or the Standard view is much faster than the Default view, then you probably have some layout in the loaded view. The biggest culprit will be a layout that opens up linked partners, gathers info, then closes the module; thus the other modules are opened/closed several times.

If it opens much faster Shared than Read then you probably cannot do much about that, but its some sort of too-many-sections issues.

If one user on a PC is slow and another fast, then that user probably has a user-specific default view with lots of layout.

 

 

 

  • Louie

 

 

Thanks Louie....

I will test it today and reply.

Regards,
Murugaraj, S

Re: Module opening is very very slow
bungle_77 - Mon Jun 30 06:35:58 EDT 2014

I have a problem. I take 20mins to open a module

I have a module baselined, with all the object purged, with no shareable edit sections, with few views. I tried to open from defferent user and machine the result is the same

I have 3000 objects, 5000 links.

If i open stanard view it opens very fast (3 second).

I have no dxl layout or triggers. I have three dxl attributes quite time consuming but none of them in the default view.

Do attributes DXL have impact also if they are not in the default view?

If i try with a script to compute the dxl attribute for each object there is not particoular object that a longer time than the others.

Anyway i have other module with similar size and same dxl attribute in the default view (with no baseline, more views) that take much less time to open.

 

One last thing if i try to open in shareable edit i have memory access error

Re: Module opening is very very slow
llandale - Mon Jun 30 14:35:21 EDT 2014

bungle_77 - Mon Jun 30 06:35:58 EDT 2014

I have a problem. I take 20mins to open a module

I have a module baselined, with all the object purged, with no shareable edit sections, with few views. I tried to open from defferent user and machine the result is the same

I have 3000 objects, 5000 links.

If i open stanard view it opens very fast (3 second).

I have no dxl layout or triggers. I have three dxl attributes quite time consuming but none of them in the default view.

Do attributes DXL have impact also if they are not in the default view?

If i try with a script to compute the dxl attribute for each object there is not particoular object that a longer time than the others.

Anyway i have other module with similar size and same dxl attribute in the default view (with no baseline, more views) that take much less time to open.

 

One last thing if i try to open in shareable edit i have memory access error

I don[t know anythnig about "Memory access Error", but it seems you need to get the Administrator to run the Intergity Checker.

I notice that all the module's Triggers, Layouts, and Attr-DXL get interpreted (but not run) whenever you open a module.  That is linearly time consuming.  But no, attr-DXL and layouts in some other view are not run when you open a view that does not contain them.

[] Check for opened modules.  From the Explorer Tools menu >>Manage Open Modules...  I'm guessing you DO have Dxl running that openes a bunch of other modules.  Open that, check it out, open your module, check it out.

[] Open the module using the standard view:  Run this DXL when the module is closed.

  • Module mod = read(NameOfModule, true,true)

[] Open the module invisibly:

  • Module mod = read(NameOfModule, false, false)

[] I think you do have DXL you don't know about.  Download "DxlFind.dxl" here, and run it on your open module.  Struggle through the sloppy print outs.

-Louie

Re: Module opening is very very slow
bungle_77 - Wed Jul 02 05:25:35 EDT 2014

llandale - Mon Jun 30 14:35:21 EDT 2014

I don[t know anythnig about "Memory access Error", but it seems you need to get the Administrator to run the Intergity Checker.

I notice that all the module's Triggers, Layouts, and Attr-DXL get interpreted (but not run) whenever you open a module.  That is linearly time consuming.  But no, attr-DXL and layouts in some other view are not run when you open a view that does not contain them.

[] Check for opened modules.  From the Explorer Tools menu >>Manage Open Modules...  I'm guessing you DO have Dxl running that openes a bunch of other modules.  Open that, check it out, open your module, check it out.

[] Open the module using the standard view:  Run this DXL when the module is closed.

  • Module mod = read(NameOfModule, true,true)

[] Open the module invisibly:

  • Module mod = read(NameOfModule, false, false)

[] I think you do have DXL you don't know about.  Download "DxlFind.dxl" here, and run it on your open module.  Struggle through the sloppy print outs.

-Louie

I run the script and i found the dxl attribute i know but also this ttrigger:

    >>>>>>>>TriggerDXL-Database 'dynamic 1':  FoundIn 'Database'  post-drop-object:

 

Do you know what is it and how to remove it? How can i locate a trigger?

 

What i found very strange is: if i open the module with standard view it take very few time. If i open the module with a view with no DXL attribute but not standard it take very long time (also if i open in read only mode).

Furthermore now  i deleted almost all the view leaving just a view with some dxl attribute as default and not it take very few time to open, i also runned the DXLfind script on this module and i found the same triggers file.Anyway i need those views i deleted so it's not a solution for my issue

Re: Module opening is very very slow
llandale - Wed Jul 02 14:02:31 EDT 2014

bungle_77 - Wed Jul 02 05:25:35 EDT 2014

I run the script and i found the dxl attribute i know but also this ttrigger:

    >>>>>>>>TriggerDXL-Database 'dynamic 1':  FoundIn 'Database'  post-drop-object:

 

Do you know what is it and how to remove it? How can i locate a trigger?

 

What i found very strange is: if i open the module with standard view it take very few time. If i open the module with a view with no DXL attribute but not standard it take very long time (also if i open in read only mode).

Furthermore now  i deleted almost all the view leaving just a view with some dxl attribute as default and not it take very few time to open, i also runned the DXLfind script on this module and i found the same triggers file.Anyway i need those views i deleted so it's not a solution for my issue

You should find two database level dynamic triggers.  These have to do with Comments/Discussions and you can ignore them.

The DxlFind script should also have found all your Attr-DXL and also all your Layouts.  Perhaps you should post the results in an attached file.

By your description, your default view seems to have some ineffecient Layout DXL.  Perhaps it is opening modules, following links, and closing modules.  If so, the view should SCROLL very slowly, and not just LOAD very slowly.

Another guess is that you have dependancies on your views.  If view "A" is defined to get its unsaved settings from view "B", then when loading "A" doors first pre-loads "B".  Thus, "B" with the ineffecient layout or attr-DXL may be your problem.  Check out Views menu >>Manage Views..

-Louie

Pre-loading: doors does not figure out which settings it should retrieve from the dependant view B, it just loads B and then loads A.  If B is dependant on C, then well C is loaded 1st.  If C is dependant on A then you have violated the natural laws of the universe and there is no saying what may happen.

Re: Module opening is very very slow
bungle_77 - Thu Jul 03 06:21:12 EDT 2014

llandale - Wed Jul 02 14:02:31 EDT 2014

You should find two database level dynamic triggers.  These have to do with Comments/Discussions and you can ignore them.

The DxlFind script should also have found all your Attr-DXL and also all your Layouts.  Perhaps you should post the results in an attached file.

By your description, your default view seems to have some ineffecient Layout DXL.  Perhaps it is opening modules, following links, and closing modules.  If so, the view should SCROLL very slowly, and not just LOAD very slowly.

Another guess is that you have dependancies on your views.  If view "A" is defined to get its unsaved settings from view "B", then when loading "A" doors first pre-loads "B".  Thus, "B" with the ineffecient layout or attr-DXL may be your problem.  Check out Views menu >>Manage Views..

-Louie

Pre-loading: doors does not figure out which settings it should retrieve from the dependant view B, it just loads B and then loads A.  If B is dependant on C, then well C is loaded 1st.  If C is dependant on A then you have violated the natural laws of the universe and there is no saying what may happen.

The default view has only three columns with no layout dxl and not dxl attribute and no depndencies.

I solved the problem removing the text color dependency of a column from another attribute (no DXL attribute)

How can it be possible?

 


Attachments

ManageViews1.png
ManageViews2.png

Re: Module opening is very very slow
llandale - Thu Jul 03 11:37:17 EDT 2014

bungle_77 - Thu Jul 03 06:21:12 EDT 2014

The default view has only three columns with no layout dxl and not dxl attribute and no depndencies.

I solved the problem removing the text color dependency of a column from another attribute (no DXL attribute)

How can it be possible?

 

You say attribute that controls the color is not attr-DXL.

Well, NOW you have me curious.  I use text color attributes quite a bit, deliberatalty greying out columns that the user is not allowed to modify, such as attr-DXL columns.  Maybe you could tell us about that other attribute and which column was using it for its color.

Also, is it just LOADING slowly or does it also SCROLL slowly?

-Louie

Re: Module opening is very very slow
bungle_77 - Thu Jul 03 12:03:22 EDT 2014

llandale - Thu Jul 03 11:37:17 EDT 2014

You say attribute that controls the color is not attr-DXL.

Well, NOW you have me curious.  I use text color attributes quite a bit, deliberatalty greying out columns that the user is not allowed to modify, such as attr-DXL columns.  Maybe you could tell us about that other attribute and which column was using it for its color.

Also, is it just LOADING slowly or does it also SCROLL slowly?

-Louie

I am sorry i was wrong it's not matter of the text color attribute.

I attach the screenshot of the module with the default view and the detail of the coloumns.

All the three attribute in the columns aree NO DXL attribute.

I can scroll quite fast.

Here the detail of the FindDXL script

 

>>>>>>>>>>> Results Follow <<<<<<<<<<<<<<
DxlFind.dxl for module 'Test Slow Module',
    </RIYADH Requirement Synthesis/Test Slow Module>
    >>>>>>>>AttrDXL: in attr 'Changed':
...
    >>>>>>>>AttrDXL: in attr 'CPS Report':
...

    >>>>>>>>AttrDXL: in attr 'ReqID':
...
    >>>>>>>>AttrDXL: in attr 'ReqStatus':
...
    >>>>>>>>AttrDXL: in attr 'Validation Method':
...
    >>>>>>>>LayoutDXL: none found
    >>>>>>>>TriggerDXL-Mod: none found
    >>>>>>>>TriggerDXL-Prj: none found
    >>>>>>>>TriggerDXL-Database 'dynamic 0':  FoundIn 'Database'  post-drag-object:

    >>>>>>>>TriggerDXL-Database 'dynamic 1':  FoundIn 'Database'  post-drop-object:


Attachments

columns.png
Module.png

Re: Module opening is very very slow
llandale - Thu Jul 03 13:41:30 EDT 2014

bungle_77 - Thu Jul 03 12:03:22 EDT 2014

I am sorry i was wrong it's not matter of the text color attribute.

I attach the screenshot of the module with the default view and the detail of the coloumns.

All the three attribute in the columns aree NO DXL attribute.

I can scroll quite fast.

Here the detail of the FindDXL script

 

>>>>>>>>>>> Results Follow <<<<<<<<<<<<<<
DxlFind.dxl for module 'Test Slow Module',
    </RIYADH Requirement Synthesis/Test Slow Module>
    >>>>>>>>AttrDXL: in attr 'Changed':
...
    >>>>>>>>AttrDXL: in attr 'CPS Report':
...

    >>>>>>>>AttrDXL: in attr 'ReqID':
...
    >>>>>>>>AttrDXL: in attr 'ReqStatus':
...
    >>>>>>>>AttrDXL: in attr 'Validation Method':
...
    >>>>>>>>LayoutDXL: none found
    >>>>>>>>TriggerDXL-Mod: none found
    >>>>>>>>TriggerDXL-Prj: none found
    >>>>>>>>TriggerDXL-Database 'dynamic 0':  FoundIn 'Database'  post-drag-object:

    >>>>>>>>TriggerDXL-Database 'dynamic 1':  FoundIn 'Database'  post-drop-object:

Close all other modules.

  • tools menu >Manage Open Modules...

Load the standard view

  • read(NameMod, true, true)

Then insert each attr-DXL individually, and see which one causes problems.

-Louie

Re: Module opening is very very slow
bungle_77 - Fri Jul 04 04:24:51 EDT 2014

llandale - Thu Jul 03 13:41:30 EDT 2014

Close all other modules.

  • tools menu >Manage Open Modules...

Load the standard view

  • read(NameMod, true, true)

Then insert each attr-DXL individually, and see which one causes problems.

-Louie

thos DXL attributes are not presente in the view and furthermore if i delete some of the views and i keep all the DXL attributes the module open in 5 seconds.

Anyway i will make your test.

Do i need to insert the dxl attribute as columin of the view?

Re: Module opening is very very slow
bungle_77 - Fri Jul 04 04:35:20 EDT 2014

bungle_77 - Fri Jul 04 04:24:51 EDT 2014

thos DXL attributes are not presente in the view and furthermore if i delete some of the views and i keep all the DXL attributes the module open in 5 seconds.

Anyway i will make your test.

Do i need to insert the dxl attribute as columin of the view?

I inserted each attribute  in the view and it take very few time for each of them

Re: Module opening is very very slow
llandale - Mon Jul 07 12:14:12 EDT 2014

bungle_77 - Fri Jul 04 04:35:20 EDT 2014

I inserted each attribute  in the view and it take very few time for each of them

OK.  I have a memory in the past where some modules opened rediculously slowly, and I deduced it was because of the excessive number of views and the terrible connection.  I'm now guessing that perhaps sometimes the view database file is getting, well not "corrupted" but perhaps "ineffecient".

I'm wondering if the following may be reasonable:

[1] Make a clone of the module
[2] Copy the views to this module
[3] Delete all views from this module
[4] Delete the corresponding "views" file from the database
[5] Re-create the views file from some empty template
[6] Copy the views back.

-Louie

Re: Module opening is very very slow
bungle_77 - Tue Jul 08 04:05:54 EDT 2014

llandale - Mon Jul 07 12:14:12 EDT 2014

OK.  I have a memory in the past where some modules opened rediculously slowly, and I deduced it was because of the excessive number of views and the terrible connection.  I'm now guessing that perhaps sometimes the view database file is getting, well not "corrupted" but perhaps "ineffecient".

I'm wondering if the following may be reasonable:

[1] Make a clone of the module
[2] Copy the views to this module
[3] Delete all views from this module
[4] Delete the corresponding "views" file from the database
[5] Re-create the views file from some empty template
[6] Copy the views back.

-Louie

Thanks Louie. I think the same too, something is corrupted in the views, because as i said before if i delete some of the views the module opens very fast. I can also create a view with all the dxl attribute and the module opens very fast.