NYCPHP Meetup

NYPHP.org

[nycphp-talk] table structure for "friend" relationships

Rob Marscher rmarscher at beaffinitive.com
Thu Jul 30 21:10:12 EDT 2009



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.




More information about the talk mailing list
Automatic Email Organization without missing anything!