Lotus Notes Database clocks and hangs when trying to open

Every time I go to open a lotus notes database,  One that I use all the time and am the designer for, it just sits and clocks and hangs notes.  I have to hit the stop button a few times, then it says operation stopped at my request.  Then when I try it again right away, it opens perfectly.
Any Ideas ???
LVL 4
pratiganAsked:
Who is Participating?
 
ThomasMcA2Connect With a Mentor Commented:
Sometimes it helps to create your own process that logs (and times) each step. Then you don't need to babysit the process, or enable debug. Exactly how you do it depends on how fancy you want to get with this feature. Here's some pseudocode for one method:
strLog = strLog & Date & Time & "about to do X"
x

strLog = strLog & Date & Time & "about to do y"
y

strLog = strLog & Date & Time & "about to do z"
z

Open in new window

Then create a Notes document that contains strLog, or send strLog to a mail-in database.

Once you have some logs saved, review the logs after you've seen performance problems, and you should be able to see which step caused the bad performance.

If you want to get fancy, save the date, time, and message about the current step into individual Notes documents (one for each step). You can then show the dates and times in a view, which would allow you to analyze trends.
0
 
ThomasMcA2Commented:
Turn on debugging, then open the database. Step through the code to find the problem.

What code runs in the database-level events? Can you debug it?

Ditto for the default view.

If you right-click > Goto > select a view that you don't use much > does the problem go away? If so, then perhaps the Initialize event for the view has a bug in it.
0
 
pratiganAuthor Commented:
appears to be network issues.  The default views and other views are inside the database and by then the response time is fine.  It only happens when I try to open the database.  I'm still checking some optimization tweaks.  I did try the debugging.  When I turn it open, the database opens fine every time... lol strange.
0
 
pratiganAuthor Commented:
I was able to perform some optimization tweaks in the database properties that have stabilized the performance of the database.
Right click on the database icons in your workspace and the last tab is for performance optimization features.
Thank You for your input.
0
All Courses

From novice to tech pro — start learning today.