If you need help with indexed query performance, you need to send us your XPATH querys that you used in your tests. A simplified sample of the documents you are indexing (at least showing the structure of the main document and indexed elements/attributes) would be useful too.
-Terry
Patrick Percot wrote:
From: Patrick Percot <[EMAIL PROTECTED]> Subject: Use of indexes Date: Sun, 29 Feb 2004 09:09:54 +0100 (CET)
Hello,
I have made some tests on xindice. It seems to be fast for some
operations, but a bit slow while performing xpath operations.
I tried to add an index on the tag used in the requests, but it took the same time with the index than without it.
What's the reason ?
I forgot to say that those tests where performed with 120 Mo of XML files of different sizes (200 files from 200Ko to 2Mo), on a laptop equipped of a Duron 1GhZ with 256 Mo of memory. I know that a 2Ghz 512 Mo machine would be a better choice.
[EMAIL PROTECTED]:/usr/src/CDS/SRD/Exemples/liens$ time /usr/local/xindice-1.1b3/bin/xindice xpath -c xmldb:xindice://localhost:8080/db/AD56 -q `cat ~/dess-asir/projet/tests/xindice/xindice-rq2` [DEBUG] DatabaseImpl - -Using SAX Driver: 'xerces' [DEBUG] DatabaseImpl - -Using Service Location: '/xindice/' [DEBUG] CollectionImpl - -Using URL: 'http://localhost:8080/xindice/'
[....]
<titleproper xmlns:src="http://xml.apache.org/xindice/Query"; src:col="/db/AD56" src:key="f9-AD50.xml">1396 W : distribution de l'�nergie �lectrique</titleproper>
real 1m43.576s user 0m1.470s sys 0m0.060s
[EMAIL PROTECTED]:/usr/src/CDS/SRD/Exemples/liens$ time /usr/local/xindice-1.1b3/bin/xindice add_indexer -c xmldb:xindice://muaddib:8080/db/AD56 -n indextitleproper -p titleproper [DEBUG] DatabaseImpl - -Using SAX Driver: 'xerces' [DEBUG] DatabaseImpl - -Using Service Location: '/xindice/' [DEBUG] CollectionImpl - -Using URL: 'http://muaddib:8080/xindice/' CREATED : indextitleproper
real 0m2.488s user 0m1.700s sys 0m0.070s
(Indexation seems to be performed in background)
[EMAIL PROTECTED]:/usr/src/CDS/SRD/Exemples/liens$ time /usr/local/xindice-1.1b3/bin/xindice xpath -c xmldb :xindice://localhost:8080/db/AD56 -q `cat ~/dess-asir/projet/tests/xindice/xindice-rq2` [DEBUG] DatabaseImpl - -Using SAX Driver: 'xerces' [DEBUG] DatabaseImpl - -Using Service Location: '/xindice/' [DEBUG] CollectionImpl - -Using URL: 'http://localhost:8080/xindice/'
[....]
<titleproper xmlns:src="http://xml.apache.org/xindice/Query"; src:col="/db/AD56" src:key="f9-AD50.xml">139 6 W : distribution de l'énergie électrique</titleproper>
real 1m42.310s user 0m1.490s sys 0m0.090s
A+ PP -- Groupe Morbihannais d'Utilisateurs de Logiciels Libres http://www.tuxbihan.org Identifiant Jabber: [EMAIL PROTECTED] GPG fingerprint = 1A4F E154 3D2C A20E E4CA A543 7951 C5C2 E44A A0B5
Patrick Percot.
A+
PP
