Hello all,I want to index all the Views before Opening the Database.Or i need to run an Agent which should index all the Views for every30 mins.
I cannot mention all the Views in the COde.
Is there any way to all the views and Index one By one
An advice is Appreciated
Thanks in Advance
Subject: How to get the Handle of all the Views in a Database
In lotusscript: notesdatabase.views
Have a look in designer help
Dan
Subject: How to get the Handle of all the Views in a Database
This could be done by a LS agent that would run on schedule, and could be called by the DB QueryOpen Event. My question is that are you sure that you want to do this? If the DB is any size the open time and re-index time could be substantial! Also, the indexes are automatically updated anyway, I have to assume that you have view sellection formulas that are based on a variable that changes, otherwise I can’t see the need for doing this. Perhaps a vew refresh might be appropriate but not building the index.
I think that you should look at your design of your application if you need to re-index all of the views every 30 minutes.
I have written agent that refresh the index before it starts processing , or after it has finished, but generally I have found that unnecessary.
Subject: How to get the Handle of all the Views in a Database
I would add a program document that run every 30 minutes. Since only one agent can run at a time agents could interfere will run times