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, vincent(a)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
_______________________________________________
devs mailing list
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs
_______________________________________________
devs mailing list
devs(a)xwiki.org