On 06/24/2013 04:49 AM, Wang, Shane wrote:
Hi
I am looking at ceilometer DB code. I find there are 3 tables (UniqueName, Event, Trait), and in
Trait, the two columns "name_id" and "event_id" refer to table UniqueName and
table Event.
My question is why we need UniqueName and Event, because in both tables there
are no many other columns, so why not fill unique_name into Trait directly.
Thanks in advance.
Hi Shane,
The purpose of the separate UniqueName table, IIRC, is to reduce the
footprint of the main Event and Trait tables. A smaller integer foreign
key can be used instead of a larger string key.
Best,
-jay
_______________________________________________
OpenStack-dev mailing list
[email protected]
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
