Project:
| View Revisions: Issue #33081 | [ All Revisions ] [ 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 | ||
| 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 | ||
| 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 |
 |