Semantic Search - Faceted Search and Web 3.0 for Drupal

212 queries to load the front page of AHIRC. That'll do it.
This happens because I am trying to emulate the "COUNT" mixed with "GROUP BY" you'd find in SQL. One company has it:
http://docs.openlinksw.com/virtuoso/rdfsparqlaggregate.html
And looks like others are anxious:
http://simile.mit.edu/mail/ReadMsg?listId=14&msgId=16326
But it's not an easy problem in a broader context:
http://www.ldodds.com/wordtin/Wiki.jsp?page=UniqueNamesAssumption

Trying to reduce the query counts produces larger results, and actually slower queries. Why? With Sesame it's because of ZEND needing to decode 6000 results from JSON. This takes 15 seconds! Oh, how nice it would be to have SPARQL with GROUP BY COUNTS.

Top Choices:
* new Sesame release with Aggregate functions? see http://www.openrdf.org/forum/mvnforum/viewthread?thread=1421
* hack ARC to allow for GROUP BY COUNT and alter SPARQL myself
* use iTQL available in Mulgara http://docs.mulgara.org/itqlcommands/select.html

More Dreaded Choices:
* rebuild the adapter in JAVA so the JASON sent is smaller, and execution faster
* hack ARC to allow for GROUP BY COUNT and alter SPARQL myself
* use openlink's virtuoso
* use the Versa Query language http://www.xml.com/lpt/a/2005/07/20/versa.html

Failed:
* see if YARS supports a GROUP BY COUNT
* see if SeQRL supports a GROUP BY COUNT
* novel SPARQL with Construct