DominoKeys.com

I attended the BP302 (App. Perf. Techniques) session at Lotusphere and felt inundated with very valuable information. Jame Magee and Kevin Marshall did a great job with the session.

For those of you who were unable to get out to Lotusphere, here are some of my favorite tips from that session:

1. Use a seperate physical disk for view indexing (the most demanding process, often 25% of the Domino server’s workload). Simply change to a new disk drive using the “View_Rebuild_Dir” item in the ini.
2. Minimize categorized columns in a view. (The more you have, the worse the performance.)
3. Lots of click-to-sort columns are bad, mm-kay? (Plus each one adds to the index process)
4. Avoid using @Today and @Now. — Instead, consider a nightly agent that moves documents into a folder and then back out again (when date matches are/aren’t met).
   
5. Reader fields cause delays if the reader has access to less than 5% of the documents (in db’s with more than 1000 docs).
6. Aliases rock! They are the fastest way to reference stuff.
7. @DBColumn and @DBLookup are always faster than using Lotuscript counterparts.
8. “For” loops are 60% faster than “Do” loops.
9. More than 3 computed subforms on a form begins to reduce performance exponentially with each one that was added. (At that point in the conference, the person next to me said “Uh oh, I have an app with 7 on one form.” — Uh oh, indeed! )
10. If you need a statement that looks like this:
    If a=x and b=y …
    then use the following one instead:
    If a=x then b=y …
    (our brains know to stop when we see “and” if the first criteria isn’t matched … however Domino keeps going because to it, “and” means “there’s more, keep going.” Using “then” stops if the first criteria isn’t valid).

Handy stuff. Can’t wait to see what they crank out next year!