Solved

Lotus Notes Database clocks and hangs when trying to open

Posted on 2014-07-30
4
436 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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

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…
This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

743 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now