Hi,
Arsen A. Gutsal schrieb:
Help me understand how powerful is Xindice.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'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?
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