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.

Kind regards,

Jens


-- 
Dipl. Inf. Jens Lehmann
Department of Computer Science, University of Leipzig
Homepage: http://www.jens-lehmann.org
GPG Key: http://jens-lehmann.org/jens_lehmann.asc

Reply via email to