Hi
I have read the Advanced User Guide section in the documentation and I
got a lot of useful information but I'm still a little bit stuck. I have
large (1 GB+) mostly single document databases and complex queries that
often take too long to execute. Apart from optimizing the queries, what are
my options to speed things up? Any ideas are welcome.
1) Vertical scaling - how does a single BaseX instance respond to adding
more CPUs or RAM? Which one could improve performance? Apart from indexing,
are there any fine-tuning options that could help improve performance?
2) Partitioning: would it make sense to break my documents into several
smaller ones, run the queries against them in parallel and then merge the
results? Has anyone done such optimization? Did it work?
2) Horizontal scaling: the docs read: *"The BaseX client-server
architecture offers ACID-safe transactions, with multiple readers and
writers."* - Where can I get a guide on how to set up a single writer -
multiple readers architecture?
Thank you
Csaba