Investigate and reduce amount of 'CACHE' SQL for Groups::GroupMembersController#index
As listed in epic: &3873 (closed), we detected several end-points that have a big amount of CACHE
SQL.
Groups::GroupMembersController#create
is one of them.
It is also very popular in terms of how many times(count
) it is invoked daily.
There are potentially several benefits if we could improve the SQL/Cached_SQL calls for this endpoint:
- from the database CPU cost perspective, 4523052 * 0.0929273990589387 / 3600 = 116 hours. So if we could make some improvements, it would reduce CPU costs.
- reduce memory consumption in Rails application.
json.meta.caller_id.keyword: Descending | Count | Max json.db_cached_count | Average json.db_duration_s |
---|---|---|---|
Groups::GroupMembersController#index | 66,760 | 113 | 0.108 |
Edited by Nikola Milojevic