[AMBARI-18976] Config History request execution time depends on config versions count

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 2.4.0
• Fix Version/s: 2.5.0
• Component/s: ambari-server
• Assignee: Papirkovskyy Myroslav Assign to me
• Reporter: Papirkovskyy Myroslav
• Created: 23/Nov/16 16:59
• Updated: 28/Nov/16 20:46
• Resolved: 28/Nov/16 16:43

Description

Request: /api/v1/clusters/tdk/configurations/service_config_versions?fields=group_id,user&minimal_response=true&from=0&page_size=10
Response always contains 10 records or less (if there are less than 10 service configs versions). Each record has only two fields (group_id, user).
Request execution time depends on overall count of service config versions in the DB.
Example:

Items Total in the DB	Response Time
2	~140 ms
100	900+ ms
290	3+ s
750	9+ s
1000	15+ s
3000	30+ s

Issue Links

• links to: reviewboard