Christian,
So, going ahead with my POC and use cases we plan to solve, I have a few more database architecture questions..
1. Is there a way, we can have a table, with multiple columns. One of the column would be "ID" and others would be different XML information for that ID.
2. Can I map above table, with a relational table to perform join queries on "ID".
Thanks, - Mansi
On Wed, Oct 8, 2014 at 12:53 PM, Christian Grün christian.gruen@gmail.com wrote:
I just created a single Database with ~190 XML files of size 8.5 GB
total.
Activated indexes as well. Creating database using basexgui took close
to an
hour. Running a simple XQUERY took ~3 min. Database was created on an external USB 3.0 HDD. I will obviously be creating new databases across drives (if this POC is successful, will surely go for cloud) to scale it.
For time being, any and all tips are welcomes to optimize performance.
Indeed performance should be much better if databases are created and queried on HDs or SSDs. Feel free to send us your queries if execution time is not good enough.
May be I will soon contribute to the statistics pages :)
Thanks, Christian