Whenever you do a LIKE you need to check your indexes in your DB to tune the query to be fast. Thanks -Vincent On 18 Sep 2014 at 11:00:36, Thomas Mortagne ([email protected](mailto:[email protected])) wrote:
It's a new implementation with a lot of caching but the model did not changed.
On Thu, Sep 18, 2014 at 10:47 AM, Paul Libbrecht wrote:
Dear XWiki developers,
again and again I see code in our Curriki (quite some of which has been written by XWiki experts) that employ LIKE hql queries to evaluate if an XWikiRights object applied to a give group or user.
I has happened often that some such queries kill our production application server; in the meantime we've managed to remove them. However, there are many more and it really appears inefficient to me.
Is the "new xwiki rights model" that has been talked about here and there an enhancement in this respect? (it is in XWiki 6 or so if I remember well, we are still at 3.5). Simply splitting the addresses of the xwikirights object in the DB could leverage effectively an index which these LIKE queries fail to do.
thanks in advance.
Paul