Forums / Developer / database: Nested Tables

database: Nested Tables

Previous topic

Developer

Next topic

Author	Message
Kai Duebbert	Saturday 28 June 2003 7:51:43 am Hi, I've read a very interesting article in the German (and ridiculously overpriced) magazine "PHP Magazin" comparing different database models for mapping hierarchical structures in relational databases. As far as I know, eZ publish uses the "Parent Model". The article demonstrated that the "Path Model" and the "Nested Tables Model" showed a dramatically increased performance. Are there any plans on using a different model in the future? Were there any thoughts about this when designing eZ publish? Best regards, Kai

Author

Message

Kai Duebbert

Saturday 28 June 2003 7:51:43 am

Hi,

I've read a very interesting article in the German (and ridiculously overpriced) magazine "PHP Magazin" comparing different database models for mapping hierarchical structures in relational databases.

As far as I know, eZ publish uses the "Parent Model". The article demonstrated that the "Path Model" and the "Nested Tables Model" showed a dramatically increased performance.

Are there any plans on using a different model in the future? Were there any thoughts about this when designing eZ publish?

Best regards,

Kai