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