[placement] db query analysis
On Mon, 24 Jun 2019, Jay Pipes wrote: >> Related to that, I've started working on a nested-perfload at >> https://review.opendev.org/665695 > > Please note that there used to be fewer queries performed in the allocation
> candidate and get resource provider functions. We replaced the giant SQL
> statements with multiple smaller SQL statements to assist in debuggability
> and tracing.
Yeah, I recall that and think it was the right thing to do, but now
we've reached a point where we've got limited choices for how to eke
out some more performance, which we're going to need to do to be
reasonable in > 10,000 node environments.
Being me I'm inclined towards things like infinite resource classes,
vector math, and "PUT IT ALL IN RAM !!!!!" but luckily its not up to
Chris Dent Ù©â??Ì¯â??Û¶ https://anticdent.org/