> 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 >
