Forums / Developer / database: Nested Tables

"Please Note:

At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

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, Exponential 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 Exponential? 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, Exponential 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 Exponential?

Best regards,

Kai