On Fri, Mar 9, 2012 at 10:07, Paul Libbrecht <[email protected]> wrote:
Hello team,
I am meeting a query at startup of my xwiki (3.1) which takes more than three minutes.
delete from xwikiproperties where xwp_name like 'editbox_%' and xwp_classtype='com.xpn.xwiki.objects.LongProperty'
I don't find where that query is made anymore, Google is becoming worse and worse to search for XWiki things, but I vaguely remember something about it.
This query is done during schema updates ! It was a very old legacy migration under MySQL for what I know, but it was implemented during the schema update processing. In 3.3, the migration system has been improved and it do only such query on very old legacy database. So, I suggest that you migrate to 3.3.
Do you all agree it is useless a delete? Should I create an SQL index just for that?
thanks in advance
paul _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
-- Denis Gervalle SOFTEC sa - CEO eGuilde sarl - CTO