[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!