Thank you for your response. Now I feel confident to add the index into my production system.
I'll try to implement the query optimization too.
26 11/22/2013 04:46:14 am
Re: Slow query in Invoice Against Sales Delivery menu (3 replies, posted in Report Bugs here)
27 11/14/2013 12:26:19 am
Re: mysqli usage (17 replies, posted in FA Modifications)
@ostertagi,
Thank you for your work. I really need it.
To be honest, I am wondering too since it might not that difficult to do simple update to newer technology.
But i do understand that some core update like database connection means another thorough test.
I will report here if there still another problem.
here is update for certain function. I have tested this function:
function db_field_name($result, $n) {
//return mysqli_field_name($result, $n);
$fieldinfo = mysqli_fetch_field_direct($result, $n);
return $fieldinfo->name;
}28 11/13/2013 11:29:03 pm
Topic: Slow query in Invoice Against Sales Delivery menu (3 replies, posted in Report Bugs here)
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?
Thank you.
Sorry for my bad English.