Solved

Lotus Notes Database clocks and hangs when trying to open

Posted on 2014-07-30
4
447 Views
Last Modified: 2014-08-05
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 ???
0
Comment
Question by:pratigan
  • 2
  • 2
4 Comments
 
LVL 14

Expert Comment

by:ThomasMcA2
ID: 40230056
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
 
LVL 4

Author Comment

by:pratigan
ID: 40234229
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
 
LVL 14

Accepted Solution

by:
ThomasMcA2 earned 500 total points
ID: 40234644
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
 
LVL 4

Author Comment

by:pratigan
ID: 40241223
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

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question