Using WITH (NOLOCK)
Posted on 2014-01-19
If I have sql queries (ADO) that are merely returning data for display, and if large numbers of queries are being requested at a given time, will adding WITH (NOLOCK) to the query minimize the deadlock issues that I am having? Is there a better way?
Here is an example of my recordset open code: rs.Open sql, conn, 1, 2
Basically I run a site that displays fitness event results and when we post results lots of folks are online trying to see their results. We get lots of deadlock errors at these times. I am trying to minimize that. I am avoiding do-while loops, using getrows() instead, whenever possible.
What else can I do?