https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15707
--- Comment #170 from Martin Renvoize <[email protected]> --- I've not really been following this one too closely yet, though it is interesting. I agree that we need a clear inheritance model defined, and personally would agree with the above comments. As a further note, I see you've chosen to use Adjacency List, and you've coded the queries yourself. Did you investigate any of the other options for storing hierarchies in a database.. Nested Set or Materialized Path perhaps, and did you not consider leaning on the shoulders of giants and using one of the DBIx::Class modules to construct the queries for you in the most optimal way for the data you require? It's important to consider future use cases, each hierarchical data model has it's strengths and it's weaknesses in terms of performance and space requirements. In general, I think Materialized Path is the defacto recommended way of doing hierarchies in relational databases now. -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
