Re: Use of indexes

From: Patrick Percot <ppercot@xxxxxxx>
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.

> 
> 
> patrick@muaddib:/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&apos;énergie électrique</titleproper>
> 
> real  1m43.576s
> user  0m1.470s
> sys   0m0.060s
> 
> 
> patrick@muaddib:/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)
> 
> patrick@muaddib:/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&apos;é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: pp@xxxxxxxxxxx
> 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: pp@xxxxxxxxxxx
GPG fingerprint = 1A4F E154 3D2C A20E E4CA  A543 7951 C5C2 E44A A0B5

Patrick Percot.