Re: [GENERAL] Enforce Symmetric Matrix

2014-05-09 Thread Randy Westlund
On Wed, May 07, 2014 at 04:07:22PM -0500, John McKown wrote: > On Wed, May 7, 2014 at 3:36 PM, Randy Westlund wrote: > > > I have a table with N (over 35k) rows. I need to compare each of > > those elements to every other element in the list, which is the > > handsha

[GENERAL] Enforce Symmetric Matrix

2014-05-07 Thread Randy Westlund
I have a table with N (over 35k) rows. I need to compare each of those elements to every other element in the list, which is the handshake problem. This results in a symmetric matrix (an adjacency matrix for an undirected graph). Because all relations are symmetric, I only need to store the uppe