Re: Lotus Notes Application Performance

["Chris Whisonant" <chris.whisonant@xxxxxxxxx>]

Timothy, I agree with Walter's reply back on the list. I doubt the Server's
RAM is the issue on this one - unless the 4GB isn't just allocated to
Domino. With you only having 3/4 of a processor, I would start here to
improve the issue. I would suggest pulling another 1/4 processor from the
other LPAR(s) on the system (assuming they're not all too heavily utilized).
You should be able to get the admin to bump this up on the fly. Hopefully
the admin will at least let you get some more cpu at least temporarily.

Let us know....
Chris

On Mon, May 5, 2008 at 6:24 PM, Timothy Briley <tlbriley@xxxxxxxxxxxxxx>
wrote:
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