On Wed, Aug 14 2013, Jay Pipes wrote: > I submitted a bug report to improve the schema of the meter table to reduce > duplication: > > https://bugs.launchpad.net/ceilometer/+bug/1211985 > > This would only affect the SQL storage driver. > > Interested in hearing thoughts on the above recommendations, which are: > > 1) Replace counter_type with an integer column counter_type_id that > references a lookup table (counter_type) > 2) Replace counter_unit with an integer column counter_unit_id that > references a lookup table (counter_unit) > 3) Replace counter_name with an integer column counter_id that references a > lookup table (counter) > > Just those three changes would reduce the overall row size for records in > the meter table by about 10%, by my calculations, which is a good > improvement for a relatively painless set of modifications.
That means we'll have to do 3 joins most of the time. Is that less costly than fetching these right away from the record? -- Julien Danjou -- Free Software hacker - freelance consultant -- http://julien.danjou.info
signature.asc
Description: PGP signature
_______________________________________________ OpenStack-dev mailing list OpenStack-dev@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev