I am experiencing a file contention issue I believe is related to increased user load.
My system specifications:
- VB.net UI/NetCOBOL
- business logic/Btrieve
- file access using a Pervasive DB.
I am seeing record locking between users who are attempting to process Sale Orders with the same Item IDs even though each individual sale order item process is wrapped in a transaction object and the parent sale order record is explicitly locked as it should be.
I can track this scenario existing back several years/releases but it only became an issue recently due to what I believe to be increased activity across increased multi-user load.
The file access methodology is purely Pessimistic and the file structures are ISAM in nature, not relational. Anybody have any insights please?