Friday, July 13, 2012

Performance improvement related standards


1. Turn off verbose logging.
2. Turn off ‘collect performance statistics’, after performance testing.
3. Try not to read a file over network.
4. In places where an opportunity for code reuse is not present, Consider output
    expressions in place of variables.
5. Using a Sequence generator provides an edge in performance over a stored  
     procedure call to get the sequence from database.
6. An Update strategy slows down the performance of the session.
7.Lookups and aggregators slow down the performance since they involve caching. It
    isadvisable to calculate and check the Index and data cache size when using them.
    Consider partitioning of files where ever necessary.

No comments: