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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
ThomasMcA2Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.