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.
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)