On Jul 30, 2009, at 9:10 PM, Rob Marscher <rmarsc...@beaffinitive.com>
wrote:
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.
Just noticed that my snip didn't make it totally clear but I'm talking
about two rows per friend relationship.
Cheers,
Rob
_______________________________________________
New York PHP User Group Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
http://www.nyphp.org/show_participation.php
