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
