I know I'm a less sophisticated user than Philip, but it seems TSQL can be
just about as dynamic as you want it to be. But it's partly about where you
want the logic, and reducing trips to the server.
So my only thing to add to the list of "when not to" is... what about
cached queries? You can't cache SP output can you? You'd want to CFQuery it
in this case.
Mark
[EMAIL PROTECTED]
> 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?
If you're building a completely dynamic bit of SQL, then you just can't do
it in a SP
Also, SPs aren't always faster - I have some SQL where the tables are
Indexed to hell and back - the CFQuery version is faster than the SP by
about 10%, don't ask me why though
Also, also, quite often we have tons of queries in a site and it's easier
to
manage without hitting hundreds of SPs than allow the SQL to be updated in
the templates
Also, also, also (this is just getting silly now), you just HAVE to do some
things in CFQuery - like altering a table structure - it'd be silly making
a
SP for a one-shot SQL statement
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
