KludgeHack

Why SELECT * Queries are bad
20 July 2007 in Databases | Comments (2)

Index coverage seems to be the one of the reasons. Selecting specific columns can make a query one hundred times more efficient.

A really nice post from Jon Galloway explains more about SELECT * queries performance. You can find it here.

So, are Database Stored Procedures Good or Bad?
11 July 2007 in Databases & Personal Experience | Comments (4)

I was doing some researching on Stored Procedures performance, and found this article on O’Reilly Databases.

Roland Bouman analyses survey data based on performance, portability and appropriateness of using Stored Procedures.

Its well known that this subject is “tricky”, mainly because his data shows most developers think Stored procedures are faster than client-side code (and SQL statements). Although the article is not focused in any database implementation, it really tries to “solve” some myths around the subject. I also agree with the author, using Stored procedures is good in some cases, and bad in others.