On Monday 08 November 2010, you wrote:
> parent_store must be used whenever we have big structures ? I don't
> htink it's usual to have very big structures for partners categories. I
> don't see the goal of doing this ?
>
++
I would like to add that parent_store may be redundant if we ever include the
pg84 enhancements. Storing the parent_left and parent_right may speed up
_reading_ of the tree, but will put a heavy burden on writing or modifying the
tree. Postgres, as of 8.4, can offer an alternative efficient way to perform
searches in tree-structured data.
--
Say NO to spam and viruses. Stop using Microsoft Windows!
On Monday 08 November 2010, you wrote:
> parent_store must be used whenever we have big structures ? I don't
> htink it's usual to have very big structures for partners categories. I
> don't see the goal of doing this ?
>
++
I would like to add that parent_store may be redundant if we ever include the
pg84 enhancements. Storing the parent_left and parent_right may speed up
_reading_ of the tree, but will put a heavy burden on writing or modifying the
tree. Postgres, as of 8.4, can offer an alternative efficient way to perform
searches in tree-structured data.
--
Say NO to spam and viruses. Stop using Microsoft Windows!