Re: Lotus Notes Application Performance

[Timothy Briley <tlbriley@xxxxxxxxxxxxxx>]

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.