Re: [xwiki-devs] useless delete at startup editbox_% ??

On Fri, Mar 9, 2012 at 12:00, Paul Libbrecht <paul(a)hoplahup.net> wrote: You may be right, I am no more sure if migration has evolve in 3.3 or 3.4. After checking, it is 3.4 ! Or is that special delete beyond migration. Schema update are independent of migration before 3.4 But you should be able to disable schema update using xwiki.store.hibernate.updateschema=0 > thanks in advance > paul > Le 9 mars 2012 à 11:42, Denis Gervalle a écrit : > > On Fri, Mar 9, 2012 at 10:07, Paul Libbrecht <paul(a)hoplahup.net> 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 > >> devs(a)xwiki.org > >> http://lists.xwiki.org/mailman/listinfo/devs > >> > > > > -- > > Denis Gervalle > > SOFTEC sa - CEO > > eGuilde sarl - CTO > > _______________________________________________ > > devs mailing list > > devs(a)xwiki.org > > http://lists.xwiki.org/mailman/listinfo/devs > _______________________________________________ > devs mailing list > devs(a)xwiki.org > http://lists.xwiki.org/mailman/listinfo/devs -- Denis Gervalle SOFTEC sa - CEO eGuilde sarl - CTO