Frequent Deadlock and lock timeout

[saravana]

Sure @smino. Also have you done any additional indexes on the fields to improve the performance?

Have raised an specific query on the same. Any inputs on these will be really helpful.

Slow Query Log Indicates Lots of Unindexed Fields searches

Team, The System begins to slow down when the DB has huge number of transactions records(Stock ledger, stock entry,Delivery Note etc). We see from the Slow Query Log that many of the searches are done based on the unindexed fields. Below are few examples against_sales_order, against_sales_invoice in delivery note item table quality_inspection in stock entry detail table reference_doctype, reference_docname in workflow action table Indexing these fields will improve the select query performa…

Thanks,
Saravana
DigixrTechnologies