List:General Discussion« Previous MessageNext Message »
From:robert_rowe Date:January 6 2004 8:40pm
Subject:Re: Bet the Business
View as plain text  
Back to stored procedures for a second. I use them with MSSQL. For certain tasks they
greatly improve performance because I don't have to move all the data client side. For the
vast majority of tasks though stored procedures yeild little performance gain. 

I've seen systems that (designed as Microsoft suggests) wrapped all SQL usage in stored
procedures. This is nonsense. 

Also, stored procedure have two very important liabilities: they break the n-tier model
and they expose source code to the customer (if you sell your app). If you change your
back end then you get to re-write all your stored procedures (I had to do this once). I
routinely get calls from IT managers who have looked at my stored procedures and have
questioned why I did so and so. This forces me to research it and come up with a
reasonable answer. 

In my opinion the performance gain of stored procedures are rarely worth the headaches so
their lack of them in MySQL is really not a problem. 

Will I use them in MySQL 5.0? Probably, but only when justified.
Bet the BusinessIan O'Rourke6 Jan
  • Re: Bet the BusinessDaniel Kasak6 Jan
  • Re: Bet the BusinessJochem van Dieten6 Jan
  • Re: Bet the Businessrobert_rowe6 Jan
    • Re: Bet the Businessian.orourke6 Jan
      • Re: Bet the BusinessMatt Davies6 Jan
  • Re: Bet the BusinessMichael Bacarella6 Jan
  • Re: Bet the Businessrobert_rowe6 Jan
    • Re: Bet the BusinessIan O'Rourke6 Jan
    • Re: Bet the BusinessMartijn Tonies6 Jan
  • ..mysql question bank.. Needed..Amanullah7 Jan
  • Re: Bet the BusinessMike7 Jan
    • Re: Bet the Businessian.orourke7 Jan
  • Re: Bet the Businessrobert_rowe7 Jan
  • Re: Bet the Businessrobert_rowe7 Jan
RE: Bet the BusinessDan Greene6 Jan
Re: Bet the BusinessUdikarni7 Jan