18 Sep
2014
18 Sep
'14
11:15 a.m.
Just to be clear you must avoid table scans at all costs.
-Vincent
On 18 Sep 2014 at 11:14:20, vincent(a)massol.net
(vincent@massol.net(mailto:vincent@massol.net)) 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
(thomas.mortagne@xwiki.com(mailto:thomas.mortagne@xwiki.com)) 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