[openstack-dev] [cinder] [manila] Performance concern on new quota system
sean.mcginnis at gmx.com
Fri Mar 9 20:50:08 UTC 2018
> On Mar 9, 2018, at 07:37, TommyLike Hu <tommylikehu at gmail.com> wrote:
> Thanks Gorka,
> To be clear, I started this discussion not because I reject this feature, instead I like it as it's much more clean and simple, compared with performance impact it solves several other issues which we hate badly. I wrote this is to point out we may have this issue, and to see whether we could improve it before it's actually landed. Better is better:)
> - Using a single query to retrieve both counts and sums instead of 2
> For this advice, I think I already combined count and sum into single query.
> - DB triggers to do the actual counting.
Please, no DB triggers. :)
> This seems a good idea, but not sure whether it could cover all of the cases we have in our quota system and whether can be easily integrated into cinder, can you share more detail on this?
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the OpenStack-dev