On 9/22/13 2:40 PM, Erich Bremer wrote:
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
Ah! It should. We'll look into this matter. Kingsley
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 triple2. 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
-- Regards, Kingsley Idehen Founder & CEO OpenLink Software Company Web: http://www.openlinksw.com Personal Weblog: http://www.openlinksw.com/blog/~kidehen Twitter/Identi.ca handle: @kidehen Google+ Profile: https://plus.google.com/112399767740508618350/about LinkedIn Profile: http://www.linkedin.com/in/kidehen
smime.p7s
Description: S/MIME Cryptographic Signature
------------------------------------------------------------------------------ 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
