[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