Hi,
We are building a solution that is actually using baseX, you can get a brief description there : http://launch.mysimplegrid.com/ The prototype works ok today for a few users. It is basically a spreadsheet UI storing its data in BaseX using the PHP library.
Our question today is about this database use. For each spreadsheet we create a database in basex which means if we have a thousand users with 20 spreadsheets each, it makes a total of 20 thousand database in basex. where each one is access by one or a few users (not simulteanously). Would it be better to create just one database containing all the spreadsheets but access by the 1000 users?
I'm looking for some information about concurrent performance and the utility of having multiple database or just one database for all?
The other option would be to store just xml as text in mysql but It's really handy to work with basex and it allows us to update single nodes when to do that with mysql I would have to save the whole xml everytime.