That definately be true.
Ya see, the real power in stored procs isn't in a "SELECT * from Squid"
statement, its in the ability to do complex processing on the SQL side, thus
relieving your webserver of work. You can build complex functions in SQL
using conditional processing, and have multiple results returned to the
requestor (that be the CFAS).
Its part of the Dilbertesque "Three Tiered Architeture" stuff... client -
webserver - database. Spread the workload between the webserver and
database, integrate business logic into the database. etc... Also, if you
integrate business logic into the database, you can keep other users who
attach to the database with tools such as Crystal Reports or MS Access in
line. There are lots of bennies in using stored procs, speed is just one of
them...
Alan McCollough
Web Programmer
Certified ColdFusion Developer
Alaska Native Medical Center
> -----Original Message-----
> From: Kevin Bridges [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, August 18, 2000 7:19 AM
> To: [EMAIL PROTECTED]
> Subject: RE: CFStoredProc
>
> I'd like to expand on this question and ask when you will actually start
> to
> see a performance difference between using a stored procedure and a query?
> I'm guessing that you need to get a bit more complex than a standard
> select
> statement to see a difference?
>
> -----Original Message-----
> From: Noel Flatters [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 18, 2000 10:53 AM
> To: [EMAIL PROTECTED]
> Subject: CFStoredProc
>
>
> I was wondering if anyone knows of any performance advantages/differences
> when invoking a stored procedure using CFSTOREDPROC vs CFQUERY??
>
> Cheers | Noel.
>
> Noel Flatters
> tdgINTERACTIVE | agribiz.net
> (e) [EMAIL PROTECTED]
> (p) 519.821.5787 ext. 5232
> (p) 1.800.794.1773 ext. 5232
> (f) 519-821-4868
>
> --------------------------------------------------------------------------
> --
> --
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> --------------------------------------------------------------------------
> ----
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
