Jonathan Melhuish wrote:
Upayavira a �crit :
Jonathan Melhuish wrote:
I'm running Xindice 1.1 on an Athlon 1.8Ghz with 512Mb RAM under Apache Tomcat. My system queries every record in a 4.9Mb database and outputs it via XML:RPC in 3.4 seconds.
Is this the sort of performance one should expect? Or is there something wrong somewhere?
Cheers,
Have you set up any indices?
I'm turned "auto-indexing" on, but it didn't seem to make much difference. I'm not convinced that it should make much difference, mind you, as it is not selectively querying the database or sorting it in any way. In fact, I'm not really convinced that it requires a database at all...
What sort of queries are you running? (Give some XPATH examples if you can).
It just pulls every record out of the database, in any order. Ie something like "xpath -c /db/db -q /root".
You (obviously) do not need any indexes at all. The purpose o the index is to select subset of documents. If you select all documents, no index needed.
Are you querying one document, or do you have lots of smaller documents in your database/collections?
There are about 30ish. Each one is pretty large as it contains an image. In the absence of any other suggestions, I will probably take the images out of the database and store them as normal files instead.
More smaller documents with proper indexes provide much better query speed-up than small amount of large documents with any indexes. This is, of course, when query returns just several documents out of hundreds / thousands.
Vadim
