Jens Lehmann wrote:
Hello Tim,

Tim Haynes wrote:
Jens Lehmann wrote:

Is there an easy way to query the number of triples in a graph
(http://geonames.org) or the whole triple store? That way I could see
how many there are and whether this number changes.
sparql SELECT count(*) from <http://geonames.org> WHERE {?s ?p ?o}

or

select count(*)
from DB.DBA.RDF_QUAD
where G = DB.DBA.RDF_MAKE_IID_OF_QNAME('http://geonames.org');

perhaps?

I already tried the first one before, but it takes some time to run
(hence the question). Finally, it outputs 68639869, which is 73% of
total Geonames triple count. On second invocation (after waiting 20
minutes), the same number is returned. But since the query is fast on
second invocation, the result might be taken from cache.

Wouldn't surprise me. Append a space to the query, or correlate with the second (SQL) query, perhaps?

~Tim
--
Tim Haynes
Product Development Consultant
OpenLink Software
<http://www.openlinksw.com/>

Reply via email to