I’ve searched through the forum and can’t quite find anything that matches this problem.
We have a simple server based database with three forms and about a dozen views. There is a fair amount of data in this database (450K records) and small number of users (less than 50). One user and one user only has an ongoing problem with response time when opening any view in the database. Everything seems to just stop for 10 or 15 or 30 seconds. This problem persists regardless of the workstation used. No other users have the same problem. I even had a second user sign on to the problem user’s PC and perform the same tasks and there was absolutely no problem at all.
All views are indexed, Refresh = Auto After First Use, Discard If Inactive for 45 days (there is a lot of activity in this database every day).
There are no Reader field columns in any views. No time functions in any columns. No problems with other databases. Just this database, just this user. Compacting the desktop gets nothing for me. I have tried dumping the user’s cache, desktop, bookmark files – nothing.
I have not had a chance to compact the database (and it needs it) but I am going to attempt this after hours tonight. Any suggestions on other tricks I can try would be appreciated. Thanks.
Subject: Response Time Opening Views - Only One User
Readers fields are not “columns” – Notes is not relational, and there may be documents that contain Readers fields regardless of the database’s design. Is the user maintaining a local replica of the database?
Subject: Response Time Opening Views - Only One User
(just guessing, but)calculating which viewentries users get (based on acl & readernames, groups, whatever) for shure takes a lot of calculations. i’m shure this isn’t done every time (would mean a lot of computations for each and every viewentry). so notes could decide to optimize views for certain/similar access levels, cause most users access view with these rights.
does this users have same rights as others?
if its a corrupt index compact (with discarding indizes) for shure is worth a try…