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