On Jul 30, 2009, at 6:33 PM, Allen Shaw <as...@polymerdb.org> wrote:
I'm thinking the multi-table joins performed twice for each search will make more of a hit in performance (and maintenance) than writing two rows for each relationship and then always being able to search only once.
I've used code like that successfully for 4 years. I'm not sure if that's even technically denormalization, but the savings in read time definitely outweigh the extra writes and storage.
_______________________________________________ New York PHP User Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/show_participation.php
