I'm doing a query like this:
<cfquery name="updateTicket" datasource="#request.dsn#"
username="#request.dbuser#" password="#request.dbpass#">
UPDATE Tickets
SET folder = <cfqueryparam cfsqltype="CF_SQL_INTEGER"
value="#getEscalationInfo.eFolder#">,
dateUpdated = <cfqueryparam cfsqltype="CF_SQL_TIMESTAMP"
value="#CreateODBCDateTime(Now())#">
WHERE ticketID IN (<cfqueryparam cfsqltype="CF_SQL_VARCHAR"
value="#tickList#" list="Yes">)
</cfquery>
The tickList can contain 20-30,000+ items, and performing this query takes
forever. What can I do to improve this a bit more? Perhaps doing multiple
updates within the <cfquery> or doing ticketID = #List[1]# OR ticketIS =
#List[2]# etc? Any ideas?
Cedric
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
