I have been working on a huge enterprise application with very fast data entry (200 client and 80~120 records per second).
We only have one tadoconnection for the whole application, with read commit isolation level. Many of my forms are using tadodataset for viewing data.
We don't need to be exact, but every time the forms loads slowly. This is due to locking mechanism, in other words uncommitted records not very important and fast loading is.
We have 2 choices:
- use
with (nolock)in all queries - add another connection with read uncommitted isolation level
I personally prefer with (nolock) because managing multiple connections is not simple, but I want to know what is benefits of either method.