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".
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.
Cheers,
Jon
