Well I've been diving into the documentation and trying out some things. (READPAST) seemed to do it for now. Haven't obtained SQL Best practises yet.
On 6/14/07, Scott Thornton <[EMAIL PROTECTED]> wrote: > > > How are you going with this? > > PS: I would try removing SET DEADLOCK_PRIORITY LOW; > > >>> "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 > > > > > > > -- *** { . } { . } **** 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 -~----------~----~----~----~------~----~------~--~---
