Anathema for Stored Procedures .....

Those in IT industry writing financial softwares know how evil yet useful stored procedures can be. Have you been in a situation wherein you have to improve the response time of your application involving execution of complex queries, but your manager says .. "No SPs here please". Although stored procedures are often viewed as the anathema of the “Write once, run anywhere” goal of Java, I have seen cases where an application that took 10–15 minutes to run as pure Java ran in well under 10 seconds with a stored procedure. The users of that system do not care about the purity of the application; they care about being able to use it to get their job done.

The question is how bad a situation has to be to force the use of SPs. SPs are useless or can even degrade the performance if used used for firing some simple queries, but can be an asset for handling any complicated business process, involving large number of complicated queries.

Guess experience comes in handy while identifying justified use of SPs, and considering how SPs behave on different platforms doing a bit of testing comes in handy before jumping into the final implementations.