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