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