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