Hi, Obtain and run SQL Best Practices Analyzer. In particular look at the tsql items.
Pay particular attention to schema binding. Also: http://www.sqlservercentral.com/columnists/skumar/tracingdeadlocks.asp http://support.microsoft.com/default.aspx/kb/263889 http://support.microsoft.com/kb/243586/ >>> "Taco Fleur" <[EMAIL PROTECTED]> 13/06/2007 2:31 pm >>> 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 -~----------~----~----~----~------~----~------~--~---
