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

Re: No Stored Procedures - Big Deal

2001-03-30 Thread John Dean
t; 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 > &g

Re: No Stored Procedures - Big Deal

2001-03-30 Thread Steve Ruby
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 agree with you on this point, a

RE: No Stored Procedures - Big Deal

2001-03-30 Thread Cal Evans
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 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 s

Re: No Stored Procedures - Big Deal

2001-03-30 Thread John Dean
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 of commonly used SQL, but then again these can be stored in a text file. The disadvantage is a down grade in performan

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 store