Shared Views Vs. Shared desktop private on first use Views

Discussion in 'Lotus Notes General Discussion' started by Vithal, Sep 24, 2003.

  1. Vithal

    Vithal Guest

    Hi,
    When I joined this new organisation there was this db created by a
    outsourced IT group. I am asked to improve it's performance. I
    observed that the size of the view indexes is much high as most of the
    views are big & almost every column is sorted both ways. The size of
    the db is 1122 MB which is tooo much for just 10088 documents.
    For performance improvement i changed all the big view as shared
    desktop private on first use, so that all indexing goes to the notes
    clients.

    I am wondering if i have done the right thing.

    Any comments ????

    thanks

    vithal
     
    Vithal, Sep 24, 2003
    #1
    1. Advertisements

  2. Vithal

    Philip Guest

    Did the performance improve ?
     
    Philip, Sep 24, 2003
    #2
    1. Advertisements

  3. Vithal

    Vithal Guest

    Hi,
    Yes Philip, the performance did improved in a big way. It improved by
    leaps & bounds. Now I would be doing the same to the live database
    after convincing my Boss who is not a techy.

    cheers

    Vithal
     
    Vithal, Sep 25, 2003
    #3
  4. sounds amazing; did these views contain Time dependent formulae? In
    that case they could have kept the server on its toes to keep them
    uptodate, especially if a lot of updating was going on. Or they
    contained a large percantage of read protected documents? So that each
    user now caches his own set of available docs?
     
    Normunds Kalnberzins, Sep 25, 2003
    #4
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.