Hi All,
Platform: MS SQL 2005
I have a simple SQL statement that simply logs a bit of data, nothing
important at all.
<cffunction
access="public"
name="doLog"
output="false"
returntype="void"
hint="Logs all details in regards to the search performed">
<cfquery
name="rsInsert"
datasource="#application.system.Datasource.getName()#">
SET DEADLOCK_PRIORITY LOW;
INSERT INTO tbl_search
(
searchString
, recordCount
, internetProtocol
, dateStamp
)
VALUES (
<cfqueryparam value="#getSearchString()#"
cfsqltype="CF_SQL_VARCHAR">
, 0
, <cfqueryparam value="#getInternetProtocol()#"
cfsqltype="CF_SQL_VARCHAR">
, <cfqueryparam value="#createODBCDateTime( getDateStamp() )#"
cfsqltype="CF_SQL_TIMESTAMP">
);
</cfquery>
</cffunction>
We are doing some load testing with the application, and it all seems to run
fine except for the above statement, it produces DEADLOCKS. I could not
really understand why, as there is ONLY an INSERT statement and the data is
not read anywhere else. The only read I could think of was for the index on
the table, I removed that, but am still getting deadlocks.
Does anyone have any idea how to overcome this?
thanks in advance.
--
http://www.clickfind.com.au
The new Australian search engine for businesses, products and services
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en
-~----------~----~----~----~------~----~------~--~---
