hello while doing some optimizations on hour database we ren into an interesting question. we are using postgres, and table inheritance works as such that when we have a query like people,insrel,articles and we have relations like posrel and publishrel extending from insrel, all these tables are searched as well. I don't think this is the kind of behavour you want for relations. why search through posrel if we are looking for an insrel? With ordinary nodes it is different: if we have 'interview' extending from 'article' and we wat all articles, we indeed want all interviews as well. So it would seem that we don't want table inheritance on relations, and performance might in fact increase dramatically in large clouds if we could drop it. Am i wrong? Do tell..
Ernst ----------- Ernst Bunders Ontwikkelaar nieuwe media Vara tel: 035 6711653 _______________________________________________ Developers mailing list [email protected] http://lists.mmbase.org/mailman/listinfo/developers
