Hi
Agreed but it still incurrs a performance penulty; more so when the server is
under heavy load
On Friday 30 March 2001 16:15, Steve Ruby wrote:
> 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
--
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
