Login
Quick Search
April182009

Query performance

by dmitriy at 18-4-2009 6:08; Wiki ID: Queryperformance

Question: I am doing a performance test of query operation in eXist,and the result following showed time consumption for query about 10 records increases when the total number of all records stored in database increases. There is no indexes.

Answer: Without an index, if your query involves a comparison, eXist has to do a full scan over all the relevant nodes in the database. The more data is in the db, the more nodes have to be scanned.

Please check http://www.exist-db.org/tuning.html and create the proper indexes.

Links
Latest Posts
AtomicWiki 0.4