NYCPHP Meetup

NYPHP.org

[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