query performance issues in 1.1

Michael Gratton <[email protected]> Mon, 04 Feb 2008 23:45:33 +1030
Newsgroups gmane.text.xml.xindice.user
Organization Quuxo Software
Message-ID <1202130933.6922.16.camel@tremelay>
Hi, 

After running 1.0-rc1 for a long long time, I finally upgraded to 1.1
the other day. But I was a bit worried to find that the performance of
queries seems to be an order of magnitude worse.

This particular database contains one really large collection (~28k
docs) of about 10 different types of documents. With 1.0-rc1 I could
execute an XPath query like "/foo", where the element `foo' was indexed
and start getting result back within a few tens of seconds. Running 1.1
with the exact same configuration takes a minute and a half.

I know the collection is rather large, but splitting it up will only
delay the problem becoming as bad for a bit longer - the number of
documents grows daily. I've tried both upgrade methods as described in
the Upgrading How-To, dropped and recreated all indexes, tried both the
XML-RPC client and running the server embedded - all with no joy.

Is there something obvious here I'm missing? Any suggestions
appreciated.

Thanks,
/Mike

-- 
Michael Gratton <[email protected]>     
Quuxo Software <http://web.quuxo.com/>
signature.asc (application/pgp-signature, 189 B)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQBHpw/1n1mVFlYUR84RAiLfAKCP3rxOpZDBi/o3d9rFc0uMt9EWvACg265c
LzQvb8bWgbKD9pufjFYB6qM=
=FBRE
-----END PGP SIGNATURE-----