« Return to Thread: 2 000 000 documents in one xml file

Re: 2 000 000 documents in one xml file

by Scorp :: Rate this Message:

Reply to Author | View in Thread

Thanks for reply

Wolfgang Meier-2 wrote:
> The query that gets all objects took 5-6 sec.

A query for //objectn should complete within a few milliseconds.
Retrieving the 2 million results could be slow, sure, depending on how
you serialize them.
All objectsn in one big xml file that i put to collection. May be it is wrong?

Wolfgang Meier-2 wrote:
I guess you did not define any indexes on prop1...prop10? See

http://exist-db.org/tuning.html

Wolfgang
Yes for that moment, but later i have read tuning article, and add indexes :-)
And it is became 4 sec to get objects by 1 property and 10 sec to get objects by 5 properties.

 « Return to Thread: 2 000 000 documents in one xml file