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 performance, which
is exactly what MySQL tries to avoid.
On Friday 30 March 2001 14:19, Gary Huntress wrote:
> 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 code....even a very simple select "oh, I can make that a
> stored procedure....because what if I change something?" <me> "then my
> code will break and I'll fix it.....*somebody* always has to change
> something!"
>
> Triggers I can understand, they take away much of my validation headaches
> (and make me correspondingly lazy), but what am I missing about the panacea
> | paradise | emerald city of stored procedures?
>
>
> Regards,
>
> Gary "SuperID" Huntress
>
> =======================================================
> FreeSQL.org offering free database hosting to developers
> Visit http://superid.dyndns.org:8080/freesql/index.php
--
Regards
John
MySQL Development Team
__ ___ ____ __ __
/ |/ /_ __/ __/ __ \/ / John Dean <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\____/ Mansfield, England, UK
<___/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php