Denis, I will consider upgrading to 3.4 or 3.5. However, I have explicitly disabled migration: WEB-INF/xwiki.cfg:xwiki.store.migration=0
Are schema-updates still done?? Or is that special delete beyond migration. thanks in advance paul Le 9 mars 2012 à 11:42, Denis Gervalle a écrit : > 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 _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
