Didn't we stop storing members of a group that way a long time ago? (implying the LIKE queries are strictly for backward compat)
On 09/18/2014 11:14 AM, [email protected] wrote: > 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 > _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
