I have transaction table like below where transaction entry will insert and after that validation is happening for transaction such as no account number perform transaction more than 5000 ( 5K) in a Month. Now in below scenario both the transaction will process successfully as its comes from different session via API in same time. <pre>tranid Amount AccountNumber TrnTime 1001 5000 12345 2021-01-31 20:20:57.713 1002 2000 12345 2021-01-31 20:20:57.713
I removed with(NOLOCK) but query performance very slow .This table contain records more than crores and same time almost 100 transactions coming per millisecond so I have restriction on removing no lock which will create locking/delay in other transaction processing.
NOLOCK
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)