07 Performance Improvement Consideration

Use UNION instead of OR

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

Continue reading


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.

Continue reading

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.

Continue reading

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:-

Continue reading