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
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
: 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
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
: 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