#1 Shift set processing to MySQL

[Kieran]

At present, graph traversal to accumulate the transitive closure in terms of gene products from a particular term is carried out in a single SQL statement.

However, the intersection of the sets returned is carried out in Java, requiring the whole set of gene products for each term to be returned, rather than just the common gene products.

If the intersection could be performed using MySQL stored procedures, this would decrease traffic between Tomcat and the MySQL server, and potentially improve performance, as MySQL may be more optimised for this kind of operation.