My PO and SO increased to about 30k, now the system is too slow when I create po and so, db lock happens often.
especially when I create a po/so which has many items (about 700+),
MySQL has gone away and
504 Gateway timeout(nginx) happened.
Any idea to diagnosis the problems or any fix?