I’ve just migrated my database to a new server (v14 Intel to v14 AMD). I’m suddenly experiencing extremely slow Sales Invoice save/submits. The offending db query seems to be the one below. It takes about 540 seconds to execute. I haven’t created any additional indexes but I didn’t have them on my previous server either. Any help would be greatly appreciated. Thanks!
select 'Journal Entry' as reference_type, t1.name as reference_name, t1.remark as remarks, t2.credit_in_account_currency as amount, t2.name as reference_row, t2.reference_name as against_order, t2.exchange_rate from `tabJournal Entry` t1, `tabJournal Entry Account` t2 where t1.name = t2.parent and t2.account = 'Debtors - LPEB' and t2.party_type = 'Customer' and t2.party = '<party_name>' and t2.is_advance = 'Yes' and t1.docstatus = 1 and credit_in_account_currency > 0 and ( (t2.reference_type = 'Sales Order' and coalesce(t2.reference_name, '') in ('SO-PEB-2223-026'))) order by t1.posting_date
ERPNext: v14.5.1 (version-14)
Frappe Framework: v14.14.1 (version-14)
Frappe HR: v1.0.0 (develop)
India Compliance: v14.0.2 (version-14)
Payments: v0.0.1 (develop)