Re: Lotus Notes Application Performance

Robert:

I sent the PMR to Walter, who was kind enough to respond, but you ask good questions as well.

"Are the performance problems a direct result of the growth of the DB? When the DB was initially rolled out was the performance acceptable ?"
Yes to both, which is frustrating because at the time of rollout this brand new server was meant to last us 5 years as configured.

"Have you(or the DB developers) looked into how the view indexes are being refreshed ?"
They are set to refresh automatically. If there's a better way, I'm open to it.

"As far as the length of time to open the main document, what is happening when the doc opens? Does it retrieve data from other documents?"

When the main doc opens, ODBC is used in the QueryOpen event to find a record in an AS/400 flat file and compare the data to a single field in the main document. If they differ, the main doc is updated with the new data, but that is only the case about 10% of the time. No other look-ups to docs are performed.

So given that performance went south with a 33% increase in the number of documents, I'd really like to know where to spend my money hardware-wise to get performance back where it was.

Thanks again,

Timothy Briley
tlbriley@xxxxxxxxxxxxxx

At 02:07 PM 5/5/2008, you wrote:

Are the performance problems a direct result of the growth of the DB ?
When the DB was initially rolled out was the performance acceptable ?

I'm no expert on this but, length of time to open a view is related to how
and when the view indexes are being refreshed. The view indexes also
consume a significant part of the DB size. Have you(or the DB developers)
looked into how the view indexes are being refreshed ?

As far as the length of time to open the main document, what is happening
when the doc opens ? Does it retrieve data from other documents ? Is so,
one way of doing that is finding the target document in a view and then
retrieving fields from the target document. If each client takes 15-30
seconds to open a view, potentially the code in the open events of the
main document will take that long to locate the target document as well.

Bob





From:
Timothy Briley <tlbriley@xxxxxxxxxxxxxx>
To:
domino400@xxxxxxxxxxxx
Date:
05/05/2008 01:40 PM
Subject:
Lotus Notes Application Performance



We use a single AS/400 9406-520 for our 45 person state agency. It
has .75 of a processor? and 4 Gigs of RAM. We installed this server
about 18 months ago and it replaced an AS/400 that we had for about
five years, so we are not new to the AS/400 platform. It's running
OS/400 v5r4 and Domino 7.02 CF1. It is primarily used for the Lotus
Notes applications which we use to pretty much run our entire agency.

Shortly after we installed this AS/400, we rolled out a pretty big
Notes application consisting of several databases. The main database
initially started out about 1.2 Gig and 300,000 documents in size,
with about 100 views.

Over time, the size of the main database has grown to 1.6 Gig and
400,000 with 114 views. But performance has really taken a hit in the
main database with many of the views taking 15 to 30 seconds to open
on a bad day and the main document taking another 30 seconds to open.
A bad day happens when about 40 users hit this Notes application.

Since we are under a maintenance contract, we've been working with
IBM to determine what to do to improve performance. They have been
unable to help in a meaningful way.

I have my own ideas about what might help:
Add more RAM to the AS/400, especially since 4 Gig doesn't seem to be
very much at all to me.
Increase the processor count from .75 (seriously, does the current
figure of .75 make sense to you?)
Increase the RAM on the PC's running the Notes clients from 512 Meg to 2
Gig.
Re-architect the main Notes database into two smaller databases.
Replace Notes views with reports where practical.

But I thought that I'd ask all of you:

If you run a Domino server on your AS/400 and have had performance
issues, what gave you more bang for the buck in improving performance?

Timothy Briley
tlbriley@xxxxxxxxxxxxxx
850 273-1433 cell

_______________________________________________
This is the Lotus Domino on the iSeries / AS400 (Domino400) mailing list
To post a message email: Domino400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/domino400
or email: Domino400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/domino400.




_______________________________________________
This is the Lotus Domino on the iSeries / AS400 (Domino400) mailing list
To post a message email: Domino400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/domino400
or email: Domino400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/domino400.