I am starting to develop an application and I am considering to use stored procedures. Is there a performance penalty for implementing many DB operations with stored procedures? For example, if my app has 50 tables, is it a good idea to write store procedures for inserting, deleting and updating data for all of them? What if, additionally, I include stored procedures for information retrieval (SELECT statements)? What would be a good criteria to decide how far to go with stored procedures?
With respect,
Jorge Maldonado