Project:
| View Revisions: Issue #33081 | [ Back to Issue ] | ||
| Summary | 0033081: There are some sql queries that can be avoided. | ||
| Revision | 2016-12-21 09:04 by NaroaIriarte | ||
| Description | There are unneeded queries in done in the "HttpSecureAppServlet.hasGeneralAccess". It is needed to improve the General Access performance by removing those unneeded queries. For example there are two queries done when the access type is "W". With a refactor it could be improved to only one query by changing this code: "SeguridadData.selectAccess(this, vars.getRole(), "TABLE", id).equals("0") && !SeguridadData.selectAccess(this, vars.getRole(), type, id).equals("0")" |
||
| Revision | 2016-12-20 17:29 by NaroaIriarte | ||
| Description | There are unneeded queries in done in the "HttpSecureAppServlet.hasGeneralAccess". It is needed to improve the General Access performance by removing those unneeded queries. | ||
| Revision | 2016-12-20 11:12 by NaroaIriarte | ||
| Steps To Reproduce | 1-As F&B Administrator go to Sales Order window. 2-Note that there are two queries, instead of one. This is (in part) because the HttpSecureAppServlet.hasGeneralAccess method, when the type is "W", does two queries. |
||
| Revision | 2016-12-20 11:12 by NaroaIriarte | ||
| Description | In the HttpSecureAppServlet.hasGeneralAccess, if the type parameter is "W", there are two queries to the same sql method. This could be modified to do only one by changing the seguridad_data.xsql and spliting the "selectAccess" method into different methods to handle different access cases. |
||
| Revision | 2016-12-14 17:21 by NaroaIriarte | ||
| Steps To Reproduce | 1-As F&B Administrator go to Sales Order window. 2-Note that there are a two of queries, instead of one. This is (in part) because the HttpSecureAppServlet.hasGeneralAccess method, when the type is "W", does two queries. |
||
| Revision | 2016-12-14 17:21 by NaroaIriarte | ||
| Description | In the HttpSecureAppServlet.hasGeneralAccess, if the type parameter is "W", there are two queries to the same sql method. This could be modified to do only one. |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |