Project:
| View Revisions: Issue #49617 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0049617: performance imporovement on the ad_session table | ||
| Revision | 2022-07-18 09:45 by egoitz | ||
| Description | On environment with lot of concurrency and lot of external calls to the server we have identified a query that is executed continuously and reading lot of information from the disk. The query is the following: select max(adsession0_.Created) as col_0_0_ from AD_Session adsession0_ where adsession0_.Username=$1 and adsession0_.Login_Status<>'F' Adding an index (username,login_status) on the ad_session table improves the performance across the System during API calls. Noticed this while analyzing the query performance in CSU customers. Contact Egoitz if there are any doubts. |
||
| Revision | 2022-06-21 13:58 by shankarb | ||
| Description | Adding an index (username,login_status) on the ad_session table improves the performance across the System during API calls. Noticed this while analyzing the query performance in CSU customer. Contact Egoitz if there are any doubts. | ||
| Revision | 2022-06-21 13:43 by shankarb | ||
| Description | Adding an index (username,login_status) on the ad_session table improves the performance across the System. Noticed this while analyzing the query performance in CSU customer. Contact Egoitz if there are any doubts. | ||
| Copyright © 2000 - 2009 MantisBT Group |
 |