Topic: Slow query in Invoice Against Sales Delivery menu
I have problem in Invoice Against Sales Delivery menu. It displays correctly, but the query is long (in my localhost experience, about 9 seconds).
After looking at the query and the database, there was small issues in the field order_ at table debtor_trans. The order_ field is not indexed. So after I add the index, the query now run normally (under half second)
Is it intended not to create index for field order_ or is it a performance bug?
Sorry for my bad English.