> read/heard somewhere that cfstoredproc only takes 3 steps to
> exectute everything and cfquery requires something like 10
> steps(might have been a dream)...I have not seen a difference
> generally.
Unfortunately, things are just not that simple.
In some cases, stored procedures may run faster than passthrough SQL. In
other cases, especially if you're using CFQUERYPARAM, you may not see any
significant difference either way. In still other cases, you may see a
decrease in performance - this is pretty rare, though.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
