15 Aug
2011
15 Aug
'11
11:14 a.m.
Actually, I see this request at each user-registration as well.
And I see it was still there on xwiki 3.0 (couldn't dig github to see further).
This is in method updateSchema which I see no reason being called at each of these, or?
(checkHibernate sounds to call it which is a bit weird to me as checkHibernate is called
at almost each store).
Any reason to keep this update?
Could I make an index to speed it?
paul
Le 15 août 2011 à 10:00, Paul Libbrecht a écrit :
Hello fellow developers,
At curriki, still running xwiki 1.5, we're having slowness at several places, in
particular user-delete which generally takes more than 5 minutes.
One of the queries that seem to take very long, from "SHOW FULL PROCESSLIST"
is:
| 192157 | dev | 63.241.108.241:44327 | currikidev_180_c | Query | 69 | updating |
delete from xwikiproperties where xwp_name like 'editbox_%' and
xwp_classtype='com.xpn.xwiki.objects.LongProperty' |
and indeed I see XWikiHibernateBaseStore to contain:
"delete from xwikiproperties where xwp_name like 'editbox_%'
and xwp_classtype='com.xpn.xwiki.objects.LongProperty'",
and
"delete from xwikilongs where xwl_name like
'editbox_%'"
the two queries seem to take the longest.
What is the reason of these deletions?
The big problem is that they contain a like clause which seems to be more developer
lazyness then actual need.
thanks in advance
Paul
_______________________________________________
devs mailing list
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs