Have anybody tried to setup Application Server to post invoices and payments in the background. The target is to avoid table locking for 70 concurent users. Will it help if NAS is installed on dedicated high performance server and does the posting while workstations only mark invoices to be posted?
You will still get locks, but if posting is done on a fast machine with fast communication to the db there will of course be shorter locks. Is it possible for you to do invoicing at off-hours? We have implemented several solutions for that with NAS and it works fine.