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