<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><br class=""><div><blockquote type="cite" class=""><div class="">On Mar 9, 2018, at 07:37, TommyLike Hu <<a href="mailto:tommylikehu@gmail.com" class="">tommylikehu@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">Thanks Gorka,<div class=""> 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:)</div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><i class=""> - Using a single query to retrieve both counts and sums instead of 2<br class=""> queries.</i><br class=""></div><div class=""><i class=""><br class=""></i></div><div class="">For this advice, I think I already combined count and sum into single query.</div><div class=""><br class=""></div><div class=""> - DB triggers to do the actual counting.<br class=""></div><div class=""><br class=""></div></div></div></blockquote><div><br class=""></div>Please, no DB triggers. :)</div><div><br class=""><blockquote type="cite" class=""><div class=""><div dir="ltr" class=""><div class="">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? </div><div class=""><br class=""></div><div class="">Thanks</div><div class="">TommyLike</div><div class=""><br class=""></div></div></div></blockquote></div><br class=""></body></html>