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 _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
