> 2. The Database connection - i.e. ODBC or preferably OLEDB does
> not have to translate a complex SQL statement, pass it off to the
> DB server and wait for the DB server to act on it. This lowers
> the overhead on the Web server in some cases quite significantly.
Just as a point on this - like SPs, it's not always the case...
I have my "favorite" query which runs faster in a CFQuery than both a view
and a SP - the View runs faster than the SP...
It's a lovely query with a sub-query, aggrigate functions and a few joins
(total of 4 tables) - it's indexed to hell and back but still takes 3+
seconds to run...
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
