I use @Today function in a view to sort documents, but it turns out that it takes a very long time to run. I want to know whether there is any alternative function to slove the problem.
I have about 2000 documents to be sorted.I have tried @Now and it is also very slow.
Subject: @today function too slow
Whenever I need to have a view select documents based on date (@Today or @Now), I construct a view that has a selection formula that selects all other criterias (except for the date) for the view. Next step is to create an agent that changes the selection forumla each night during low utilization of the server. This agent hardcodes the current date into the selection formula. Then the view index can be rebuilt during the night and the view should then be fast to use during daytime.
But be aware; If You are using a template, then the agent that changes the view formula must be run AFTER the nightly design task or the view formula will be reset to be a view formula without date criteria…
hth
Subject: RE: @today function too slow
Also see IBM Support Web site Techdoc, Time/Date views in Notes: What are the options?, provides alternate ways of creating date-based views.
Subject: Please Post the formula for the sorted colums…
and the view selection formula
Tell us a bit more about the documents and the stored items you use in the views
and let us know the business function you are trying to achieve.
perhaps we may be able to suggest an alternative approach
Subject: @today function too slow
You guys help me a lot.Thank you very much.
Subject: @today function too slow
You should never use functions like @Today or @Now in a view since the view index will always have to be rebuilt (hence possibly taking a very long time to create).
A better solution is to save the date in the document and use that date in the view selection.
Ruedi Berger