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?


>
EXPERT RESPONSE
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
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
How to refresh all Lotus Notes documents via a background agent
Creating Domino doclink buttons
Locating file upload controls
DbColumn look-up generates too many results

Lotus Notes Domino Application Development
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
A smorgasbord of Notes/Domino development tips
A project-tracking application for Lotus Notes Domino

Lotus Domino Designer
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
Using LotusScript to retrieve names of fields on a Lotus Notes form
Top 10 Lotus Notes Domino programming and development tips of 2007
A bevy of Notes/Domino development tips
A smorgasbord of Notes/Domino development tips
Lotus Notes' document check-in/check-out functionality

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

HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersDomino IT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




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