how powerful is Xindice?

["Arsen A. Gutsal" <ar...@softsky.com.ua>]

Help me understand how powerful is Xindice.
I've the project which use some data. Currently I've it in Xindice
v1.1b4.
Everything works fine, but I'm not sure how it will work if my Customers
table will contain over 100'000 records? 
I'm using select from customers xml table based on ID (string field) and
Password (string field).
It's much more suitable for me rather then using MySQL or another
relational database.
But, is it viable and can I use it for commercial websites with
hundereds of thousands visitors?

-- 
Sincerely,
Arsen A. Gutsal
SOFTSKY Ltd CEO/Executive
SOFTSKY - Cost effective Software Development

Re: how powerful is Xindice?

[Torsten Steinert <To...@web.de>]

Hi,

Arsen A. Gutsal schrieb:
> Help me understand how powerful is Xindice.
> I've the project which use some data. Currently I've it in Xindice
> v1.1b4.
> Everything works fine, but I'm not sure how it will work if my Customers
> table will contain over 100'000 records? 
I guess that depends on how you structure your xml data. Xindice is not 
suitable for processing a single, large xml document. If i recall 
correctly, xindice handles best documents well below 1 MB. You would 
have to search the mailing list archives for further information.

> I'm using select from customers xml table based on ID (string field) and
> Password (string field).
> It's much more suitable for me rather then using MySQL or another
> relational database.
> But, is it viable and can I use it for commercial websites with
> hundereds of thousands visitors?


If you structure your data in a way so that you have lots of small xml
documents, each document contains one customer, then xindice is very 
suitable.
I did a small student project where i benchmarked xindice and on other 
xml database. The data stored in the database were small xml documents 
(less than 1 KB each). Xindice could handle more than 100.000 documents 
easily without any noticeable performance degradation. The benchmark 
contained inserts, modifys, deletes and selects.

Hope this helped,

Torsten Steinert

Re: how powerful is Xindice?

[Timothy Murphy <ti...@birdsnest.maths.tcd.ie>]

On Wednesday 09 March 2005 12:36, Arsen A. Gutsal wrote:

> Help me understand how powerful is Xindice.

I'd love to see a simple, short, document
with a straightforward Xindice example.

The documents I have seen all seem to assume
one already has a doctorate in the subject.

-- 
Timothy Murphy  
e-mail (<80k only): tim /at/ birdsnest.maths.tcd.ie
tel: +353-86-2336090, +353-1-2842366
s-mail: School of Mathematics, Trinity College, Dublin 2, Ireland