Hi Peter,

thanks for the link. There’s no general answer for your question, as an application may both run flawlessly with a single or hundreds of databases, depending on how your XQuery expressions look like. If you do regular updates, I suggest to split your data into fixed instances that will never change, and use all indexes, and updating instances that may eventually be merged with the fixed instances if no more changes are expected.

Christian ___________________________

On Sun, Jan 13, 2013 at 1:09 AM, pw@themail.co.uk wrote:

Hello List

I am experimenting with statistical data ( http://www.semantechs.co.uk/ ) and found that organising 2.5Gb of xml data into 12 unevenly sized collections ranging from 40 to 400Mb performs much more slowly than 36 collections each containing approximately 75Mb of data.

What rules of thumb are there to guide me in designing the most performant database?

Many thanks

Peter

---

BaseX-Talk mailing list BaseX-Talk@mailman.uni-konstanz.de https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk