Hi Geert, Many thanks for your helpful answers. I was not able to open the link to the thread. Yes, I can get now number of triples statistics using Xquery function as you suggested.
Just a naive question: Does that mean there are some queries in SPARQL 1.1 that are not fully handle yet? Is there any mention somewhere in the documentation to know when to issue XQUERY instead of pure SPARQL ones? Cheers, Ghislain Le mer. 15 mars 2017 à 15:13, Geert Josten <[email protected]> a écrit : > Hi Ghislain, > > I’m afraid there is no good answer yet. Most common way I’ve counted > triples myself if by using fn:count(cts:triples()), but according to this > thread: > > https://lists.marklogic.com/message/j5pxmjjktakhianb > > ..both approach involve deduping triples, which causes either approach to > be slow. Things might have progressed with ML9, so if you haven’t tried > that, could be worth giving that a go. > > The only other option that comes to mind right now is > http://docs.marklogic.com/cts:triple-value-statistics. Just run that > without args, and it should return a total count. From the looks of it that > is a non-deduplicated count, as it is higher than the count of cts:triples, > when I tried on a small set of triples locally. > > Cheers, > Geert > > From: <[email protected]> on behalf of Ghislain > Atemezing-Pro <[email protected]> > Reply-To: MarkLogic Developer Discussion <[email protected]> > Date: Wednesday, March 15, 2017 at 10:49 AM > To: "[email protected]" <[email protected]> > Subject: [MarkLogic Dev General] Counting triples operation never end > > Hi, > I have created and uploaded a database consisting of 727 Mio of triples. > The database configuration has the triple index set to true, and I get can > make simple query like `*select distinct ?s where {?s ?p ?o} limit 10 `* > I wanted to know the exact number of triples using the /qconsole by making a > > *select (count(*) as ?total) where {?s ?p ?o * > * }* > However this operation never gives me any result. > > Also how can I get the number of triples from the MLCP tool as it said : > `OUTPUT_RECORDS_COMMITTED: 7280660`. Is there a way to compute the number > of triples from the notion of "records" in Marklogic? > > Thanks in advance. > Best, > Ghislain > -- > -------------------------------------------- > Ghislain A. Atemezing, Ph.D > R&D Engineer > @ Mondeca, Paris, France > Labs: http://labs.mondeca.com > Tel: +33 (0)1 4111 3034 <+33%201%2041%2011%2030%2034> > Web: www.mondeca.com > Twitter: @gatemezing > About Me: http://atemezing.org > > _______________________________________________ > General mailing list > [email protected] > Manage your subscription at: > http://developer.marklogic.com/mailman/listinfo/general > -- -------------------------------------------- Ghislain A. Atemezing, Ph.D R&D Engineer @ Mondeca, Paris, France Labs: http://labs.mondeca.com Tel: +33 (0)1 4111 3034 Web: www.mondeca.com Twitter: @gatemezing About Me: http://atemezing.org
_______________________________________________ General mailing list [email protected] Manage your subscription at: http://developer.marklogic.com/mailman/listinfo/general
