Cedric Villat wrote:
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
Well, by using a list like that, you are kind of defeating the indexing mechanism of
the SQL server. You could try to simplify the list by grouping it in large sequential
chunks and using the BETWEEN operator.
You also want to make sure that TicketID is indexed (if not the primary key).
HTH
2 matches
Mail list logo