In my application , I have a shared-private on first use view .Everytime I click on the view to view the documents it takes more time then normal.
Is there any notes specific issue ??
Please Help…
thanks!!
Subject: Why Private view takes time everytime I open??
There are a couple of things that could be causing that.
It could be that the database has a large number of updates between your use of the view.
For example, consider a database with a large number of records, and a nightly agent that updates each record. That agent can also have the server update all of the regular views as part of it’s process.
When you open your private view, Notes needs to process every document in the database (since they have all changed) in order to refresh your index.
If you view is only slow the first time you open it each day, the above situation could be happening.
The other explanation is that you have used @Today, or @Now in your view. That requires Notes to rebuild the view from scratch each time it’s used, which is slow if the database has many records.
Subject: RE: Why Private view takes time everytime I open??
thanks Richards , one more thing if you can help me
You are right , when my app opens my private view is the default view so it takes 3-4 mins by watch to open the db as @now and @today and some date comparisons are being performed in the view.
Is there any alternate solution to this problem? pls do help …
Subject: RE: Why Private view takes time everytime I open??
Without knowing what user requirement you’re trying to fulfill by using @Now/@Today, it’s hard to suggest an alternate way to meet the requirement.
Subject: RE: Why Private view takes time everytime I open??
See th requirements are quite clear , here the problem is if
this formula language code can be moved to some other
place or written in some other way (may be in LS) in the
private view so that we achieve the functionality as well as
get rid of the problem of processing time which is more than normal…
Subject: RE: Why Private view takes time everytime I open??
I still did not hear much about WHY you are trying to use a reference to now in a view. Your solution might be as simple as removing references to @Now & @Today and then categorizing based on a date field, then let your users find the date they are interested in. A step further would be to embed that in a form as a single-category view. Tell us more.