> On Mar 9, 2018, at 07:37, TommyLike Hu <[email protected]> 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
>      queries.
> 
> 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? 
> 
> Thanks
> TommyLike
> 

__________________________________________________________________________
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: [email protected]?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev

Reply via email to