Just to be clear you must avoid table scans at all costs. -Vincent
On 18 Sep 2014 at 11:14:20, [email protected] ([email protected](mailto:[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
