> On 4 Mar 2018, at 12:20, Ludovic Dubost <[email protected]> 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. 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" <[email protected]> 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
