Hello,
On one database (mailfile) I have a slow response time when trying to acces it (not all the time, but often). This is the only database that I can observed this problem. This databse is used by some peoples (between 5 and 15).
Where can I start to investigate this problem?
Thanks
Subject: RE: slow response time
Run routing check on it.fixup -F
compact -c -D
updall -R
Also make sure database does not have views that have any date/time selection formulas or views that frequently discard index.
Deleting loval cache.ndk and desktop6.ndk also can help.
Subject: RE: slow response time
thanks, I will try that.
Subject: Re: slow response time
We had a simlilar issue with a web application that moved from R6 to ND6. Turned out to be an unread mark issue. If all these apply to you, turning off maintaining the unread marks might be a good test.
Good luck!