Hi Kingsley,
My statement about the triple count SPARQL query was only to state
that my virtuoso wasn't frozen for other queries. Historically, for all
of my virtuoso 6.x installs:
select distinct ?g where {graph ?g {?s ?p ?o}}
and
select count(*) as ?cc where {?s ?p ?o}
have always worked quick, so, I never bothered to optimize either as you
specified :-)
And since:
select distinct ?g where {graph ?g {?s ?p ?o}}
has always worked quicked for me in virtuoso 6.X, it just seemed
natural/reasonable to think something weird was going on when it didn't
work quick in virutoso 7 as it has and does in virtuoso 6 - Erich
On 09/22/13 9:50 AM, Kingsley Idehen wrote:
On 9/22/13 8:32 AM, Hugh Williams wrote:
a) select distinct ?g where {graph ?g {?s ?p ?o}}
from the SPARQL endpoint and it timed out.
however, the following query against http://www.geonames.org would work
in a second:
b) select count(*) as ?cc where {?s ?p ?o}
The issue is that listing all the named graph IRIs in a quad store is
much different from getting a count of all the triples in a named graph.
Count of named graph IRIs would be:
SELECT COUNT(*) WHERE {GRAPH ?g {?s ?p ?o}} .
You can reduce the cost of this quest using:
SELECT COUNT(*) WHERE {GRAPH ?g {?s a ?o}} .
Examples using the LOD cloud cache instance:
1.
http://lod.openlinksw.com/sparql?default-graph-uri=&query=SELECT+COUNT%28*%29+WHERE+%7BGRAPH+%3Fg+%7B%3Fs+%3Fp+%3Fo%7D%7D+&format=text%2Fhtml&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000&debug=on
-- count of all named graphs associated with any triple
2.
http://lod.openlinksw.com/sparql?default-graph-uri=&query=SELECT+COUNT%28*%29+WHERE+%7BGRAPH+%3Fg+%7B%3Fs+a+%3Fo%7D%7D+&format=text%2Fhtml&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000&debug=on
-- count of all name graphs associate with isA relation based triples.
------------------------------------------------------------------------------
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/22/13.
http://pubads.g.doubleclick.net/gampad/clk?id=64545871&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/22/13.
http://pubads.g.doubleclick.net/gampad/clk?id=64545871&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
