I agree, stored procedures are usually the best way to go, but as a general rule I develop using cfqueries and migrate them to SPs as and when required.
There are many reasons for this (crazy security policies / dev leads who don't like using sp's as they like to see "everything in one page" / internal politics / etc etc etc.. general corporate crap, usually) but quite often, it's because the spec changes so often in development, its just not worth using SPs until the damn thing settles down a bit. -----Original Message----- From: Ellis Wood [mailto:[EMAIL PROTECTED] Sent: 06 August 2004 11:33 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Exceptions I second that notion. -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 06 August 2004 10:18 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Exceptions True enough but again...if your queries are complex they should really be in Stored Procedures and the QEP should be modified as in certain RDBMS' the EP is not optimum - it's a rough 'guess' and can be significantly improved by user intervention. Using an SP over a CFQUERY should IMHO be paramount (of course, only if your RDBMS allows them!) -----Original Message----- From: Alistair Davidson [mailto:[EMAIL PROTECTED] Sent: 06 August 2004 10:56 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Exceptions > 2] It makes the query run faster because the datatype is explicitly set. The speed increase that you *can* get from CFQUERYPARAM is more due to the fact that it allows your DB engine to cache the query's execution plan, as it will recognize that the same query with different parameters is just that. Without CFQUERYPARAM, it may (depending on the engine) have to recompile the query every time it executes. This difference is not much of a problem on simple queries, but it becomes more noticeable the more complex your query becomes (multiple joins, CASE statements, etc) Alistair Davidson Senior Technical Developer Headshift.com ------------------------------------------ HEADSHIFT >> www.headshift.com T: 020 7357 7358 ------------------------------------------ smarter > simpler > social > -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
