I would think it would have the tiniest affect on the DB server as far as being able to type correctly, but probably any speed there would be lost in CF compiling. Never tested though.
-Nic Richard Dillman wrote: > I know that a pounded variable in a cfuery alwasy should be cfqueryparam'd > And ive herd it actually makes the Query run faster. > > but what about non pounded variables > take the folowing query: > <cfquery name="ListFams" datasource="#dsn#" username="#dbusername#" > password="#dbpassword#"> > SELECT Child_ID, Firstname, sibs > FROM tbl_children > WHERE DispWithFamily = 1 and Availability = 1 AND sibs = <cfqueryparam > value="#form.sibs#" cfsqltype="CF_SQL_INTEGER" /> > ORDER BY sibs DESC > </cfquery> > > Would the query gain a speed benifit like this? > <cfquery name="ListFams" datasource="#dsn#" username="#dbusername#" > password="#dbpassword#"> > SELECT Child_ID, Firstname, sibs > FROM tbl_children > WHERE DispWithFamily = <cfqueryparam value="1" cfsqltype="CF_SQL_TINYINT" > /> > AND Availability = <cfqueryparam value="1" cfsqltype="CF_SQL_TINYINT" /> > AND sibs = <cfqueryparam value="#form.sibs#" cfsqltype="CF_SQL_INTEGER" /> > ORDER BY sibs DESC > </cfquery> > > hard to tell with only 400 records,,, but in a years time this table should > be upwards of 300,000 records so every bit of speed i can get... > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256452 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
