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 > [email protected] > http://lists.xwiki.org/mailman/listinfo/devs _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
