Hi,
The Dtree and WebNides table contains almost same information. Wanted to know, what is the use of WebNodes table, I mean, WHat extra information it contains?
When we use Dtree and when Webnodes?
Hi Siddharth,
WebNodes is not a table.
It is a database View of some of the more useful columns from several tables of the core document model in the schema.
That is DTree, DVersData (for the current version) and KUAF.
By defining a view on several tables, those columns can be retrieved simply.
The table join logic is in the view definition, so selecting from the view means you do not need to write the join condition.
So it helps from a programmatic and administrator viewpoint and also from a DB resource usage viewpoint.
When to use it?
Whenever you want to get the info it contains rather than write a more complex statement including that join condition.
So that would be when you want info for the current version of a DTree object.
In practise, you would probably not write many statements using the view once you become familiar with the schema.
Regards
Lindsay
From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: 2012 August 09, Thu 10:17To: eLink RecipientSubject: Webnodes DB table usage
Webnodes DB table usage
Posted bysiddharth_fadnis@infosys.com (Fadnis, Siddharth) On 08-09-2012 05:11
[To post a comment, use the normal reply function]
Forum:
Content Server LiveReports Forum
Content Server:
Knowledge Center
