To clarify - I forgot to mention that the trace event outputs to the log when a SPARQL query is executed.
On 25/03/14 12:01, Clark Richey wrote: > Thanks! > > -------------------- > Clark Richey, CTO > FactGem > 240-252-7507 <tel:240-252-7507> > [email protected] <mailto:[email protected]> > > > Need immediate assistance? Please try: > > Cate Downing, Assistant > [email protected] <mailto:[email protected]> > 614.325.2404 <tel:614.325.2404> > > Beth Price, Assistant > [email protected] <mailto:[email protected]> > 614.365.0740 <tel:614.365.0740> > > This message and any included attachments are property of FactGem and > its affiliates, and are intended only for the addressee(s). The > information contained herein may include trade secrets or privileged or > otherwise confidential information. Unauthorized review, forwarding, > printing, copying, distributing, or using such information is strictly > prohibited and may be unlawful. If you received this message in error, > or have reason to believe you are not authorized to receive it, please > promptly delete this message and notify the sender by e-mail. Thank you. > > > On Mar 25, 2014, at 8:00, "John Snelson" <[email protected] > <mailto:[email protected]>> wrote: > >> The easy way is to use cts:count() and "item-frequency" with >> cts:triples(). But it's not very fast. >> >> The more complicated way is to turn on the "SPARQL Value Frequencies" >> trace event, which will output something like this: >> >> 2014-03-21 17:29:10.386 Info: [Event:id=SPARQL Value Frequencies] >> sessionKey=3215158362941807382 values= >> 2014-03-21 17:29:10.386 Info: () = count:4000038, sUniq:187066, >> pUniq:67, oUniq:494586 >> 2014-03-21 17:29:10.386 Info: >> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> = freq:187057, s: >> (count:0, pUniq: 0, oUniq: 0), p: (count:187057, sUniq: 187057, oUniq: >> 12), o: (count:0, sUniq: 0, pUniq: 0) >> 2014-03-21 17:29:10.386 Info: <http://xmlns.com/foaf/0.1/Document> = >> freq:10, s: (count:0, pUniq: 0, oUniq: 0), p: (count:0, sUniq: 0, oUniq: >> 0), o: (count:10, sUniq: 10, pUniq: 2) >> >> The value you want is the one after "() = count:", in this case 4000036. >> Divide that by 3 to get the number of triples in all stands of the >> database (so 1333346 in this case). That number will include triples in >> deleted documents that haven't been merged out of the stands yet. >> >> John >> >> On 24/03/14 18:10, Clark Richey wrote: >>> Is there an easy way to determine the number of total triples in the DB? >>> I have triples insides of other documents. >>> >>> -------------------- >>> Clark Richey, CTO >>> FactGem >>> 240-252-7507 >>> [email protected] <mailto:[email protected]> <mailto:[email protected]> >>> >>> >>> >>> >>> Need immediate assistance? Please try: >>> >>> Cate Downing, Assistant Beth Price, Assistant >>> [email protected] <mailto:[email protected]> <mailto:[email protected]> >>> [email protected] <mailto:[email protected]> >>> <mailto:[email protected]> >>> 614.325.2404 614.365.0740 >>> >>> This message and any included attachments are property of FactGem and >>> its affiliates, and are intended only for the addressee(s). The >>> information contained herein may include trade secrets or privileged or >>> otherwise confidential information. Unauthorized review, forwarding, >>> printing, copying, distributing, or using such information is strictly >>> prohibited and may be unlawful. If you received this message in error, >>> or have reason to believe you are not authorized to receive it, please >>> promptly delete this message and notify the sender by e-mail. Thank you. >>> >>> >>> >>> >>> >>> _______________________________________________ >>> General mailing list >>> [email protected] <mailto:[email protected]> >>> http://developer.marklogic.com/mailman/listinfo/general >>> >> >> >> -- >> John Snelson, Lead Engineer http://twitter.com/jpcs >> MarkLogic Corporation http://www.marklogic.com >> _______________________________________________ >> General mailing list >> [email protected] <mailto:[email protected]> >> http://developer.marklogic.com/mailman/listinfo/general > > > _______________________________________________ > General mailing list > [email protected] > http://developer.marklogic.com/mailman/listinfo/general > -- John Snelson, Lead Engineer http://twitter.com/jpcs MarkLogic Corporation http://www.marklogic.com _______________________________________________ General mailing list [email protected] http://developer.marklogic.com/mailman/listinfo/general
