> cfstoredproc should be faster, but I've only seen the
> opposite being true. Like it is important though if one
> function is 0.00001 ms faster than the other function ;)
If you're just calling stored procedures from CFQUERY, I doubt it'll be any
slower than calling them from CFSTOREDPROC.
> I prefer cfquery because it makes my code more readable, and
> I see no reason to use cfstoredproc unless multiple datasets
> are returned.
There are other reasons to use CFSTOREDPROC instead of calling stored
procedures from CFQUERY. You can pass parameters in and out (a big thing in
the Oracle world, apparently) and catch return codes. In addition, I don't
think all databases support the use of stored procedure invocation from
within CFQUERY.
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]
