Project:
| View Revisions: Issue #35590 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0035590: AD_IsOrgIncluded performance improvements | ||
| Revision | 2017-04-07 14:29 by aferraz | ||
| Description | AD_IsOrgIncluded is a database function that receives three parameters: ad_org_id, parent_org_id and ad_client_id and returns the level in the organization tree for the given ad_client_id where ad_org_id is with respect to parent_org_id. If not in the natural tree, it returns -1 This function is used in many places as part of the where clause specially in functional flow related SQL queries. It would be very interesting to improve this function performance, so it will automatically improve the performance of every place that calls it. http://wiki.openbravo.com/wiki/Projects:AD_IsOrgIncluded_Performance_Improvements [^] |
||
| Revision | 2017-04-04 16:46 by aferraz | ||
| Description | AD_IsOrgIncluded is a database function that receives three parameters: ad_org_id, parent_org_id and ad_client_id and returns the level in the organization tree for the given ad_client_id where ad_org_id is with respect to parent_org_id. If not in the natural tree, it returns -1 This function is used in many places as part of the where clause specially in functional flow related SQL queries. It would be very interesting to improve this function performance, so it will automatically improve the performance of every place that calls it. |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |