3-clique counting in a graph
        Posted  
        
            by Legend
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by Legend
        
        
        
        Published on 2010-05-16T02:37:55Z
        Indexed on 
            2010/05/16
            2:40 UTC
        
        
        Read the original article
        Hit count: 229
        
I am operating on a (not so) large graph having about 380K edges. I wrote a program to count the number of 3-cliques in the graph. A quick example:
List of edges:
A - B
B - C
C - A
C - D
List of cliques:
A - B - C
A 3-clique is nothing but a triangle in a graph. Currently, I am doing this using PHP+MySQL. As expected, it is not fast enough. Is there a way to do this in pure MySQL? (perhaps a way to insert all 3-cliques into a table?)
© Stack Overflow or respective owner