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-----