Hello all,
I'm considering BaseX for a project of mine but before I go any further I have a few questions.
First some facts:
- I need to store up to perhaps 50.000 documents in each database (collection) at about 1MB in average size.
- One database will be queried of up to 5 users at a time on average, each one issuing 50 times more reads than writes. I would say perhaps 50 rather simple reads (queries) a minute (most queries will be done against a single document at a time).
- Ideally each server should host up to 50 such databases.
Now to my questions:
1) Will the number of databases have a performance hit (degredation) on the system as a whole other than that caused be the extra number of concurrent users?
2) Can I expect a performance hit on a given database related to the number of concurrent users on that database, even if those users are mostly quering different documents?
3) Will the number of documents in a given database have a performance hit on queries done against that database?
4) Are there any limitations in BaseX that I should possibly be aware of?
I would also like to know what my options are for backing up the databases (preferably while in use), and what I can do to repair a database if a document somehow become corrupted due to a software malfunction?
Finally I would like to hear if BaseX is being used for other critical applications other than mine where stability and fast response times is essential?
Thank you for your time,
Regards Erik