Forum Post: RE: sql92 openedge 11.4 causing performance problems

  • Thread starter Thread starter Paul Koufalis
  • Start date Start date
Status
Not open for further replies.
P

Paul Koufalis

Guest
Are you using an existing ODBC DSN? Did you remember to change the isolation level when you created the new one with the 64 bit drivers? (Yes yes I know you probably did but this is for the benefit of the reader). Are you writing your own queries? If yes you can add "WITH NOLOCK" to the query. From the documentation: The NOLOCK locking hint ensures records are not locked during the execution of a SELECT statement when the transaction isolation level is set to READ COMMITTED.

Continue reading...
 
Status
Not open for further replies.
Back
Top