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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.