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



--
- Mansi