Also the SOLR API you used is checking the right for each result which is not the case for the xwql one.
On Mon, Mar 5, 2018 at 9:31 AM, Vincent Massol <vinc...@massol.net> wrote: > > >> On 5 Mar 2018, at 09:28, Thomas Mortagne <thomas.morta...@xwiki.com> wrote: >> >> Well "XWQL" does not really mean much since that's not what is >> executed. Better indicate the database you are comparing with SOLR, I >> guess it's HSQLDB here. You would most probably don't get the same >> result with a different database and it also depends a lot on the >> database configuration (how much is cached, etc.). > > Good point. > > It’s still interesting to know that with our standalone distribution it would > be faster with XWQL on HSQLDB than SOLR queries. > > Next step: test this on mysql. > > Thanks > -Vincent >> >> On Sun, Mar 4, 2018 at 12:46 PM, Vincent Massol <vinc...@massol.net> wrote: >>> >>> >>>> On 4 Mar 2018, at 12:36, Vincent Massol <vinc...@massol.net> wrote: >>>> >>>> >>>> >>>>> On 4 Mar 2018, at 12:20, Ludovic Dubost <ludo...@xwiki.com> wrote: >>>>> >>>>> Hi >>>>> >>>>> This is interesting. >>>>> >>>>> Now I believe these results might change under volume and also depending >>>>> on >>>>> the type of queries. A like on xwql/hql would be slow while a solr text >>>>> search would give fast results. >>>> >>>> Yes I agree. Obviously if we want to check this further we need to do more >>>> tests. Doing a “LIKE” one is interesting. I’ll try to do one. >>> >>> On a small data set, the advantage is still for XWQL, see >>> http://snippets.xwiki.org/xwiki/bin/view/Extension/Performance%20of%20SOLRQL%20vs%20XWQL/#HXPropertyLIKE >>> >>> Note that the majority of queries done by XWiki during a page rendering are >>> done on small result set. >>> >>> But indeed, it would be interesting to load XWiki with, say 2M pages and do >>> the test again. >>> >>> Thanks >>> -Vincent >>> >>>> >>>> I’m lacking the data to do volume testing both in term of quantity of data >>>> and in term of load on XWiki. >>>> >>>> Another point to consider: this test is done with SOLR being embedded >>>> (which should provide the best perf on low volumes IMO). On larger volumes >>>> you’d need to use an external SOLR which would perform better but you’d >>>> suffer from the marshalling/unmarshalling of requests/responses. >>>> >>>> Thanks >>>> -Vincent >>>> >>>>> >>>>> Ludovic >>>>> >>>>> Le 4 mars 2018 11:46, "Vincent Massol" <vinc...@massol.net> a écrit : >>>>> >>>>> Hi devs, >>>>> >>>>> I was curious to know how SOLRQL compared vs XWQL (for example to progress >>>>> on the idea of moving more to using SOLRQL for doing queries and thus >>>>> being >>>>> able for ex to use a store based on, say, git). >>>>> >>>>> I put my quick result here: http://snippets.xwiki.org/ >>>>> xwiki/bin/view/Extension/Performance%20of%20SOLRQL%20vs%20XWQL/ >>>>> >>>>> In short, it seems that XWQL wins by a factor of at least x2. >>>>> >>>>> Is that your experience too? >>>>> >>>>> Let me know if I’ve made a mistake somewhere. >>>>> >>>>> Thanks >>>>> -Vincent >>>> >>> >> >> >> >> -- >> Thomas Mortagne > -- Thomas Mortagne
