No Stored Procedures - Big Deal

2001-03-30 Thread Gary Huntress
I don't mean to be argumentative, but what is everyones love affair with stored procedures? I like putting my logic in the mid-tier and I'm constantly battling my Sybase Admin at work who maligns me whenever they spot a query in my codeeven a very simple select "oh, I can make that a

RE: No Stored Procedures - Big Deal

2001-03-30 Thread Cal Evans
Dean [mailto:[EMAIL PROTECTED]] Sent: Friday, March 30, 2001 7:50 AM To: Gary Huntress; Mysql (E-mail) Subject: Re: No Stored Procedures - Big Deal Hi I must agree with you on this point, after what can be done in a stored procedure can also be done with SQL. The only real advantage I can see

Re: No Stored Procedures - Big Deal

2001-03-30 Thread Steve Ruby
: Friday, March 30, 2001 7:50 AM To: Gary Huntress; Mysql (E-mail) Subject: Re: No Stored Procedures - Big Deal Hi I must agree with you on this point, after what can be done in a stored procedure can also be done with SQL. The only real advantage I can see to provide a centralized store

Re: No Stored Procedures - Big Deal

2001-03-30 Thread John Dean
much be compiled each time it is submitted. IMHO, Cal http://www.calevans.com -Original Message- From: John Dean [mailto:[EMAIL PROTECTED]] Sent: Friday, March 30, 2001 7:50 AM To: Gary Huntress; Mysql (E-mail) Subject: Re: No Stored Procedures - Big Deal Hi I must

RE: No Stored Procedures - Big Deal

2001-03-30 Thread Cal Evans
: John Dean [mailto:[EMAIL PROTECTED]] Sent: Friday, March 30, 2001 9:24 AM To: Steve Ruby; Cal Evans Cc: Gary Huntress; Mysql (E-mail) Subject: Re: No Stored Procedures - Big Deal Hi Agreed but it still incurrs a performance penulty; more so when the server is under heavy load On Friday 30 March