Comment 13 for bug 1180438

A Typical installation gets in the millions of entries per day. You can see that if it takes 6 minutes to query 12k records we have a serious problem. There is a good doc laying out the data amounts here: https://docs.google.com/a/morphlabs.com/spreadsheet/ccc?key=0AtziNGvs-uPudDhRbEJJOHFXV3d0ZGc1WE9NLTVPX0E#gid=0

@xingzhou This sound correct from what I saw in logs. If you enable query logging in your DB and issue a 'ceilometer meter list' you will see queries happening for the full response time duration (in our case 30+ minutes of joins/subqueries).