Monday, October 27, 2008

My Favorites database properties

  • Don't maintain unread marks: This can ruin performance - unread marks should only be used if really needed
  • Don't use the "Don't support specialized responses hierachy" - If you do, you can read responses from Lotus Script (doc.responses.count is always zero)
  • Use LZ1 compression: Yep - this makes sense. Less storage and less traffic
  • Allow more fields in database. Can't find any drawbacks from this - and sometimes it is needed -> so, it's an 'always on' for me
  • Allow soft deletions: Users loves this. Just remember to set the expire time high (336 for 2 weeks or more)
  • I also limit the $UpdatedBy and $Revisions fields - no need to track everything

    More info here

0 comments:

 
Creative Commons License
This work is licensed under a Creative Commons Attribution 3.0 Unported License.