You are viewing a plain text version of this content. The canonical link for it is here.
Posted to xindice-users@xml.apache.org by Jonathan Melhuish <j....@signal.qinetiq.com> on 2004/02/24 13:24:15 UTC
Performance?
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,
Jon
Re: Performance?
Posted by Vadim Gritsenko <va...@reverycodes.com>.
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
Re: Performance?
Posted by Jonathan Melhuish <j....@signal.qinetiq.com>.
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
Re: Performance?
Posted by Upayavira <uv...@upaya.co.uk>.
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?
What sort of queries are you running? (Give some XPATH examples if you can).
Are you querying one document, or do you have lots of smaller documents
in your database/collections?
Upayavira
Re: Starting and stopping Xindice under Linux Redhat 9
Posted by Vadim Gritsenko <va...@reverycodes.com>.
Achille Kamgno-Tatuebu wrote:
>Hi,
>
>I have installed Xindice on Linux redhat 9.
>
>
Version? For 1.1 use:
http://cvs.apache.org/viewcvs.cgi/*checkout*/xml-xindice/xindice.sh?rev=1.13
Vadim
Starting and stopping Xindice under Linux Redhat 9
Posted by Achille Kamgno-Tatuebu <sl...@uni-duisburg.de>.
Hi,
I have installed Xindice on Linux redhat 9.
Before I could start xindice server without problems, but now When I
start the server with the command "./start" in the Linux terminal I get
the following reply:
Environment
-----------
XINDICE_HOME = /usr/xindice
A Xindice instance is already running with PID 19716
when I try to create a collection with "xindiceadmin ac -c /db -n
addressbook" for instance, I get the following error message:
ERROR : A connection to the Database instance 'db' could
not be created. Error: Connection refused
Then I decided to close Xindice and restart it again.
When I do so using the command "./xindice.server stop" then I get:
./xindice.server: line 40: kill: (19716) - No such
process
When I type "./xindice.server restart", I get:
Restarting Xindice with pid 19716
./xindice.server: line 50: kill: (19716) - No such
process
Even using the Linux command "kill" to end Xindice doesn't help. I typed
"Kill 19716" and I got:
bash: kill: (19716) - No such process
My environment variables JAVA_HOME and XINDICE_HOME
have been set correctly. The $XINDICE_HOME/bin directory has been
also added to my PATH environment variable.
I don't know what to do to get Xindice running again,
can someone help me?
Thanks
Achille