simple queries as it goes along with the way I tend to code
applications. Once the application is architected I can site down and
write all the stored procedures and test the DB side of the system out.
In addition to that I always setup 5 DSNs per application:
APPNAME_DSN, //For use within cftransaction since the DSNs need to be
the same across queries
APPNAME_DSN_SELECT,
APPNAME_DSN_INSERT,
APPNAME_DSN_UPDATE,
APPNAME_DSN_DELETE,
which allows an additional layer of security for your applications.
In regards to cfif and cfswitch I tend to use cfif/cfelse when there are
only 1 or two possibilities and cfswitch/cfcase when the conditions are
numerous. I have never really noticed a difference btween using the two.
Mike
Michael T. Tangorre
________________________________
From: Adkins, Randy [mailto:[EMAIL PROTECTED]
Sent: Friday, September 17, 2004 10:32 AM
To: CF-Community
Subject: RE: Metrics?
Excellent, .. I will see what I can find on the HoF site as
well.
Did a Google and found some comments stating the difference
however nothing backing it up and that is what I am seeking
Any help is greatly appreciated!!
________________________________
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: Friday, September 17, 2004 10:28 AM
To: CF-Community
Subject: RE: Metrics?
Dave Watts always has good info on the uses of stored procs
versus
cfquery and Mikey D has a lot of info on those compairons....
Michael T. Tangorre
________________________________
From: Adkins, Randy [mailto:[EMAIL PROTECTED]
Sent: Friday, September 17, 2004 10:18 AM
To: CF-Community
Subject: Metrics?
Does anyone have any metrics outlining the differences between
the
following:
Using CFSWITCH vs. CFIF statements (looking for performance
numbers)
Using CFStoredprocs vs. standard CFQUERY
________________________________
________________________________
________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
