How come nobody has mentioned that complex data manipulation can be performed
on the server without waistuful and slow transmission of unwanted data
to the client? that seems like the biggest advantage to me.
Meaning that if I have to do something to the data that SQL doesn't allow
without SPs I have to send large datasets to the client to be manipulated,
with SPs data manipulation can be done on the server (which is typicaly more
powerful) and then only the smaller answer data is returned to the client.
Cal Evans wrote:
>
> Stored procedures offer several advantages over embedded SQL.
>
> 1: It is easier to write, debug and modify SQL code in a stored procedure
> with a tool designed to do that. You can write PHP from the command line
> also but not many people do it.
>
> 2: Placing the code in a stored procedure allows you to divorce it from your
> other code and debug it separately.
>
> 3: It allows for easier division of labor. In our shop, we routinely hand
> off the SP's to the data team.
>
> 4: Stored procedures allow for a greater degree of code reuse.
>
> But the biggest advantage.
> 5: Stored procedures are normally (Oracle, MS SQL, Interbase, etc.) compiled
> code. They are compiled once and used in their compiled state until they
> are modified. This offers faster execution than embedded sql, which 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 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
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
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
