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:
Post a Comment