18 Sep
2014
18 Sep
'14
11:14 a.m.
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