I have a rather large cfquery slowing me down. i can build simple stored procs
but I dont know anything advanced.
Can you take a cfquery like this
<cfquery name="getname" datasource="dsn">
SELECT name, address, zipcode, city, state,etc,etc,etc
<cfif form.name IS NOT "">AND name = '#form.name#'</cfif>
<cfif form.zipcode IS NOT "">IN zipcode =
<cfif form.cityIS NOT "">IN city = '#form.city#'</cfif>
I have like 15 if's in trhe statement. Is this feasible in SQL stored procs or
will it actually hurt performance more?...