I'm under the impression that when selecting data, this is true on some
RDBMS's
~Simon
Simon Horwith
Macromedia Certified Instructor
Certified ColdFusion Developer
Fig Leaf Software
1400 16th St NW, # 500
Washington DC 20036
202.797.6570 (direct line)
www.figleaf.com
-----Original Message-----
From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 29, 2001 8:56 AM
To: CF-Community
Subject: RE: Stored procedures...when would you
Isn't in true that there are significant performance gains when using Views
instead of Tables? What are some of the limitations of Views? For
example, they're not updatable right....
At 08:50 AM 3/29/01 -0500, you wrote:
>While SP's are faster the majority of the time but not always, as was
>already stated, another factor is the RDBMS it's running against. I
believe
>Oracle isn't really optimized for SP performance, though there certainly
are
>benefits aside from speed to consider.
>
>~Simon
>
>Simon Horwith
>Macromedia Certified Instructor
>Certified ColdFusion Developer
>Fig Leaf Software
>1400 16th St NW, # 500
>Washington DC 20036
>202.797.6570 (direct line)
>www.figleaf.com
>
>
>
>-----Original Message-----
>From: Angel Stewart [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, March 28, 2001 11:17 PM
>To: CF-Community
>Subject: Stored procedures...when would you
>
>
>NOT want to use stored procedures to run queries etc. on a database?
>
>Wouldn't a stored procedure almost always run faster than one done through
>CF?
>
>-Gel
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
