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