[nycphp-talk] table structure for "friend" relationships
Rob Marscher
rmarscher at beaffinitive.com
Fri Jul 31 00:42:57 EDT 2009
On Jul 30, 2009, at 9:10 PM, Rob Marscher <rmarscher at beaffinitive.com>
wrote:
> On Jul 30, 2009, at 6:33 PM, Allen Shaw <ashaw at 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
More information about the talk
mailing list