Project:
| View Revisions: Issue #49617 | [ Back to Issue ] | ||
| Summary | 0049617: performance imporovement on the ad_session table | ||
| Revision | 2022-07-18 09:45 by egoitz | ||
| Steps To Reproduce | Having pg_stat_statements installed on the database of a customer with lot of concurrencies, we have taken some statistics about the information read. The result is that for the query on the ad-sesion table, many TB of disk are readed. The data read per execution is 788MB but as the query is executed many times, the accumulated data read is really high. To enable pg_stat_statemnts: http://wiki.openbravo.com/wiki/Finding_Perfomance_Issues#Tracking_SQL_Statements [^] |
||
| 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 | ||
| Steps To Reproduce | General speed in query results after adding the index in API calls. | ||
| 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 | ||
| Steps To Reproduce | General speed in query results after adding the index. | ||
| 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 |
 |