Re: [Exist-open] XQuery performances + tests

[Adam R. <ada...@de...>]

I am very interested in eXist performance as I have to purchase a =
server
soon to run eXist on and deliver a web application with eXist that will
have initially ~4000 documents in a collection but may have upto 30,000
documents.


I also have a Pentium M 1.60GHz laptop with Sun JVM 1.40

It has 2GB or RAM although I could remove 1GB for the test.

The main difference is that it is running SuSE Linux 9.3 Professional
(Kernel 2.6.11.4-21.9-default) instead of Windows XP.

I would like to repeat your experiment and compare the results, if you
would also be interested in this could you send me the documents you
stored in the collection. Also could you please send me a copy of the
original document you used to produce the PDF so I can update it with =
my
results for comparisson. Also did you take the first execution time for
the query from the admin client or the second (I believe the query's =
can
be cached), I have certainly noticed that running the query several
times gives different response times, I usually take the mean time of =
10
executions.

I also have access to other hardware that may be interesting to test -=20
Solaris 10 on Sparc Ultra 10 and a Dual SMP Intel PIII @ 450Mhz with =
any
x86 OS I fancy.


Thanks Adam Retter



On Wed, 2005-09-14 at 15:42 +0100, C=C3=A9dric Meier wrote:
> Hi all,
>=20
> We are using eXist in a PHP web site project for 2 main points (for
> the moment): A project management module and a documents management
> module. On each of these modules we have to provide some lists for =
the
> interfaces (eg: list of last added documents or list of opened
> projects). Testing our application with more than 200 documents per
> collection was quite slow... So I started to make some tests.
>=20
> The eXist database works fine for us (no more stability or corruption
> problems since months) but the performances decrease with a "large"
> collection. To verify this I made some tests with the java client
> provided with eXist (to exclude the PHP part of the project) and
> reported the time on a small graph (see attached PDF file for details
> of tests).
>=20
> The result of these tests is that eXist is quite slow when querying =
in
> collections. For example, a simple XQuery (without "order by" or
> access to other collections) needs more than 10 seconds to process on
> a collection of 1'000 documents!
>=20
> I've not seen such tests on the mailing list till now and I wanted to
> give you my feedback. I would really apreciate to read your =
reactions.
>=20
> Here are some questions:
> What do you think about using eXist in a such context (lists of
> collections, etc.)? Is that really suitable for this (performances,
> capacity)?
> What do you think about my tests? Are they realistic? Are they a
> representation of what the eXist database should do?
> Are my XQueries totally wrong written? (see attached PDF)
> What's your reactions with this problem? Is that a problem for you
> too?
>=20
> Thanks in advance for your answers!
>=20
> C=C3=A9dric Meier