Jiwa Sales order Performance issues
Posted: Thu Aug 01, 2024 2:37 pm
We have a customer that is getting performance issues with Jiwa related to sales orders, the symptoms are as follows:
Things that have been tried to alleviate the problem are
We are wating for the customer to approve archiving sales order data as this is a fairly old database and has over 4 million records in SO_Lines, which hopefully will occur in the next day or so.
The question is are there any other ideas which could be tried?
- Unless the database is reindexed and restatted daily quite oftern user can't open the sales order screen.
A scheduled plugin that runs quite often reports read errors from the sales order business object, errors in the event log about timeouts.
Things that have been tried to alleviate the problem are
- Changing all custom SQL reads against these tables to use no lock, this includes the stored procs for sales orders and invoices.
Making sure the scheduled plugins don't run overnight for when the reindexing will run
Having Jiwa auto log off any users so there are also not users logged in when the reindexing runs
Seperating scheduled plugins into their own service each
We are wating for the customer to approve archiving sales order data as this is a fairly old database and has over 4 million records in SO_Lines, which hopefully will occur in the next day or so.
The question is are there any other ideas which could be tried?