On Fri, Mar 9, 2012 at 12:00, Paul Libbrecht <[email protected]> wrote:
> Denis, > > I will consider upgrading to 3.4 or 3.5. > 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 ! > 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. > 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 <[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 > -- Denis Gervalle SOFTEC sa - CEO eGuilde sarl - CTO _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
