Home > Ask the Domino Experts > Application Development Questions & Answers > Clarifying "Discard view index if not used in 45 days" property
Ask The Domino Expert: Questions & Answers
EMAIL THIS

Clarifying "Discard view index if not used in 45 days" property

Brian Mahoney EXPERT RESPONSE FROM: Brian Mahoney

Pose a Question
Other Domino Categories
Meet all Domino Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 19 March 2005
It was explained to me by one of our corporate Notes gurus that the "Discard view index if not used in 45 days" property removes the index for views if the view has not been used in 45 days, which saves space in the database. The index is then re-created once a user opens the view again. However, after reading the documentation in the Designer R5 Help database, I am not sure that this information is correct.

First, my corporate Lotus Notes environment does not use the setting in the INI file to control this. Second, in the Domino R5 Designer help, it states that the property does this:

"Deletes a view index if the view hasn't been used in a specified number of days. Domino rebuilds the view index the next time a user opens the database."

So how is this saving any space if we use this view property? The next day when the database is opened by a user, the index is re-created anyway. I was thinking that maybe it was misstated and really meant the next time the view was opened.

Can you clarify how this property works exactly? Does the index get created the next time the database is opened or the next time the view is opened?


>
I haven't reverified the functionality recently, but the intent is to remove the key index of a particular view if it hasn't been used in x days. If a view is used daily then there are no advantages to using this feature. However, if you have a special view that is used only occasionally, say only at month end, and have it set to expire after 7 days of inactivity, you do get some advantage.

I have found this most useful with the types of views that are rarely needed used but are needed. They index may take up a great amount of space, but that is regained after a few days, until the view is used again.

Do you have comments on this Ask the Expert question and response? Let us know.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
Application Development
Calculating results for a column in a Lotus Notes view
Do I use Formula or LotusScript to include a doclink to a Notes view?
'Customize this view' options are disabled in Lotus Notes databases
Give external users access to workflow-based Notes Domino applications
Setting the field value of a table
Troubleshooting non-delivery of agent notification e-mails
Exporting data from Microsoft Excel to Lotus Notes
How to send a form to a non-Lotus Notes email client
Manipulating the replication and form of profile documents
How to create an icon on an HTML page that opens the Lotus Notes database from a Lotus Notes client

Lotus Notes Domino Application Development
Create a dynamic user-driven navigator for a Notes/Domino application
Top 10 Lotus Notes/Domino coding and development tips of 2008
Lotus Notes Domino application development best practices
Mimic Lotus Notes Domino application functionality on the Web
Top 10 issues when developing Lotus Notes Domino Internet applications
Top 10 Lotus Notes Domino programming and development tips of 2007
Export Lotus Notes documents to Microsoft Word via Internet Explorer
A bevy of Notes/Domino development tips
How to protect your Lotus Notes application design
Adding an action to the Lotus Notes right-click menu

Lotus Domino Designer
Setting up a Domino 8.5 XPages example
An introduction to using XPages in Domino 8.5
Top 10 Lotus Notes/Domino coding and development tips of 2008
'Customize this view' options are disabled in Lotus Notes databases
Stop response documents from showing in a Lotus Notes form
Set a value in a field existing in another Lotus Notes database
Display Lotus Notes fields as separate entries in one column
An introduction to Lotus Domino Designer
Modifying LotusScript code for date and time handling
Creating custom Lotus Notes Domino login forms

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



Lotus Notes Domino on Blackberry and mobile devices
HomeTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersDomino IT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 1999 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts