Hello,
I am doing some performance analysis on size of XML files in DB, no of records in a result set and how much time it takes to get me results.
Currently, I have 150GB worth of XML documents imported into BaseXDB. It took roughly 21 minutes to return back result set worth 5.3 million records.
Queries are of below form:
http://localhost:8984/rest?run=get_query.xq&n=/Archives/*/descendant::c/..., "xyz")]/@name/data()
XQUERY File: for $db in db:list() (: Assign dynamic variables to generate query, to be used in eval :) let $query := "declare variable $db external; " || "db:open($db)" || $n return xquery:eval($query,map { 'db': $db, 'query': $n })
I have been few questions around this.
1. I have been routinely advices on this email chain, to avoid serialization from XPATH and let xquery handle it. I tried a few things like replacing strings() with data(), adding serialization option on REST call, in XQUERY file etc. But, I don't see any performance gain. Is there something else I can try or something, I am doing wrong ?
2. Does anyone have any resource to compare this performance to other NoSQL databases. I am just very curious, how above performance numbers compares to other DBs ?
- Mansi