07 Performance Improvement Consideration


Use UNION instead of OR

Consider using UNION when you have to use OR condition on 2 index columns

07 Performance Improvement Consideration

Advertisements

Coding for Performance : for vs. foreach


Use the MeasureIt program described in Chapter 1 to see for yourself the difference in iterating collections using for loops or foreach. Using standard for loops is significantly faster in all the cases. However, if you do your own simple test, you might notice equivalent performance depending on the scenario. In many cases, .NET will actually convert simple foreach statements into standard for loops.

Coding for Performance : for vs. foreach

Coding for Performance : Casting


In general, you should avoid casting wherever possible. Casting often indicates poor class design, but there are times when it is required. It is relatively common to need to convert between unsigned and signed integers between various third-party APIs, for example. Casting objects should be much rarer.

Coding for Performance : Casting

Performance tuning of SQL Queries (Oracle)


Contents copied from http://geekexplains.blogspot.com/2008/06/how-to-tune-sql-queries-for-better.html

Performance of the SQL queries of an application often play a big role in the overall performance of the underlying application. The response time may at times be really irritating for the end users if the application doesn’t have fine-tuned SQL queries. There are sevaral ways of tuning SQl statements, few of which are:-

Performance tuning of SQL Queries (Oracle)