Xindice performance

[Paul Gowers]

I have today been playing with Xindice to see what it could do. I have to say, even with limited hardware (200MHz Pentium Pro running NT4) I was a little disappointed. I used the command line tools to create 1000 XML documents based on files on my computer. The documents were very small and looked like this:   <?xml version="1.0"?> <direntry> <name>f://ffastun.ffl</name>    <size>229376</size> </direntry>   Query using command line tools by exact element match (no indexes) took around 25 seconds. With an index on size, an exact match search took over 10 seconds. Using -t long made no discernable difference - with or without was same speed.   E:\>xindiceadmin add_indexer -c /db/files -n sizeindex -p size -t long CREATED : sizeindex   E:\>xindice xpath -c /db/files -q "/direntry[size=709]" <?xml version="1.0"?> <direntry xmlns:src=""http://xml.apache.org/xindice/Query">http://xml.apache.org/xindice/Query" src:col="/db/files" src:key="file500.xml"> <name>f://user_data/HELEN/children/action man_files/aman_link.gif</name>    <size>709</size> </direntry>   I would be interested to hear what other users' experiences are. It is entirely possible I have screwed something in the config. I have been trying it "out of the box". That said, 10 seconds to find by exact match on an indexed value which is pretty selective was disappointing. I am used to RDBMS performance, which would be sub-second even on my woeful hardware.   Cheers Paul