These are chat archives for ManageIQ/manageiq/performance

28th
Jun 2016
Marcel Hild
@durandom
Jun 28 2016 06:59
@kbrock nope, but now :clock9:
Keenan Brock
@kbrock
Jun 28 2016 11:26
:)
@durandom ManageIQ/manageiq#9453 - I've wondered the same thing about index ordering
Keenan Brock
@kbrock
Jun 28 2016 12:04
nothing like starting the day off realizing that you optimized a model/query from who knows what to N+1. (but you thought you got it to 2 queries)
while I guess it was an impovement... it is bitter sweet.
Marcel Hild
@durandom
Jun 28 2016 13:25
@kbrock yeah. I played with it a bit and it all depends on the type of queries we do. E.g. (not even polymorph related) we dont have an index on type in Vms. This could result in a full table scan, depending on how many providers you have configured...
but in the end, I guess there is other, lower hanging fruit, when it comes to performance :)
Keenan Brock
@kbrock
Jun 28 2016 14:19
@Fryguy specs were green... then I "fixed" a rubocop and specs go red.
But I do like when you split up a method into 2 and it says that each of them are too complex... basically agreeing with the split up in the first place
Jason Frey
@Fryguy
Jun 28 2016 14:22
haha
Keenan Brock
@kbrock
Jun 28 2016 14:32
@Fryguy for ManageIQ/manageiq#9350
a) would you like to see what the individual querys look like and how much data comes back?
b) do you want me to change table and miq_expression so I can show how an individual page changes? (I was thinking about holding off here but that is up to you)
Jason Frey
@Fryguy
Jun 28 2016 14:34
merged :)
Keenan Brock
@kbrock
Jun 28 2016 14:34
ooh - thanks
Keenan Brock
@kbrock
Jun 28 2016 14:48
@Fryguy today is the day! (that you get time to work on time series dbs) ;)
Jason Frey
@Fryguy
Jun 28 2016 14:56
LOL maybe ¯\_(ツ)_/¯
I have to review LiveMetrics stuff first though...going to use that as a base