The application we are writing requires that we use with(NOLOCK)in our requests. Just so that the requests do not take so much time.
I did not find anything on how to do this. I found how to enable optimistic or pessimistic locking, but as far as I know, this is for writing data, not reading.
Is there any way to do this?
We use the JPA and criteria API that connect to the MSSQL server, and the application server uses Glassfish 4.
Erates
source
share