i have been working on huge enterprise application fast data entry (200 client , 80~120 records per second).
we have 1 tadoconnection whole application, read commit isolation level. many of forms using tadodataset viewing data.
we don't need exact, every time forms loads slowly. due locking mechanism, in other words uncommitted records not important , fast loading is.
we have 2 choices:
- use
with (nolock)in queries - add connection read uncommitted isolation level
i prefer with (nolock) because managing multiple connections not simple, want know benefits of either method.
Comments
Post a Comment