These are chat archives for ManageIQ/manageiq/performance

27th
Jul 2016
Keenan Brock
@kbrock
Jul 27 2016 14:14

so 67% of the queries (and 80% of the rows) coming back for cap & u are looking up relationships
I just focused on improving vm.parent_blue_folder (8 queries -> 3 queries) and vm.parent_resource_pool (4 queries -> 3 queries)

ms bytes objects queries query (ms) rows comments
137,628.8 385,205,217* 146,079,320 82,208 44,337.9 106,046 before-1
111,007.1 247,647,720* 106,595,193 57,206 36,762.6 71,046 after-1
19% 27% 30% 17% 33% improvement

@Fryguy do you have a chance to help me verify these code changes?
I'm hoping you can discern what changes I can make to the relationships api

to be honest, I was hoping for more of an improvement, but 20-30% is nothing to snub
@Fryguy there is a pattern in that code that looks fishy for 1/2(?) of the relationship queries