IBM®
Skip to main content
    Country/region select      Terms of use
 
 
   
     Home      Products      Services & solutions      Support & downloads      My account     

developerWorks  >  Lotus  >  Forums & community  >  Best Practice Makes Perfect

Best Practice Makes Perfect

A collaboration with Domino developers about how to do it and how to get it right in Domino

While I'm thinking about indexing options...

One thing I don't recall having seen mentioned previously is the effect of indexing options on views that use @Today or @Now. These views are a performance issue (in case you didn't know) because the view index is always considered out of date, so every time a user opens it, the index is discarded and created fresh, which takes a lot longer than just updating an existing index with any documents created or modified since last use.

If you do have a view that uses @Today, and you want to improve the performance without doing a lot of work, you can just set the indexing options to refresh "Auto, at most every x hours," with a reasonable value for x depending on the needs of your application -- say, 6 hours, so you know it's always up to date with today's data by 6 AM. This might not be suitable for all applications -- it depends how likely the documents are to change during the day and how important it is that such changes show in the view immediately. Bear in mind that users can update the view manually via F9 whenever they wish (if they were about to take a coffee break anyway), and you can also programmatically refresh the view using NotesView.Refresh (e.g. in a server agent that runs when documents are modified) so that at least your users don't have to wait for it.

@Now is more problematic than @Today because it really does generally need to be up to the minute (e.g. red-flag requests that are more than 2 hours old), so in that case you may either have to accept the performance hit, or come up with a different way to satisfy the requirement (e.g. agent sends urgent email to someone when the request is old).

Andre Guirard | 1 February 2008 07:00:00 AM ET | Plymouth, MN, USA | Comments (2)

Search this blog 

Disclaimer 

    About IBM Privacy Contact