9 Mar
2012
9 Mar
'12
11:42 a.m.
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