Hi,
I was noticing that in Content Server, in addition to DTreeMultilingual there are tables created for each metadata language, i.e. WebNodesMeta_en_US, WebNodesMetada_fr. These tables seem to change in lock-step, the only difference is the DTreeMultilingual will by default get entries for the system default language while for each enabled metadata language, an entry is created in WebNodesMetadata_<locale> for each object, whether the user has entered anyting for the locale or not. in the case where no additional info is entered, it gets the SDL value recorded.
I also noticed that there are views for the WebNodeMetadata tables (i.e. Webnode_en_US, Webnode_fr) which do a join between DTree(code) and WebNodeMetadata_<locale>.
Given that this means that the same data is duplicated from DTreeMultilingual to WebNodeMetada_<locale> is there any reason why WebNodeMetada_<locale> tables exist? Or do they exist so that in the view, there is always a 1:1 relationship between the DTree entry and the WebNodeMetadata_<locale> entry?
I know it's a bit of a nitpicky question, but for some reason, the WebNodesMetadata tables came up while discussing what are the busiest tables in the system.
-Hugh
