Hi,
This is a follow up to the benchmarking work I presented at the user
meeting in Prague.
I have made some changes to my BenchX application to allow the split option
(-s) of xmgen to be used. http://www.xml-benchmark.org/faq.txt
I have compared the timings for databases created from sources with and
without the -s option. In principle these should provide very similar
results.
xmlgen /f 0.2 /o folder/auction
xmlgen /f 0.2 /o folder/auction /s 400
In the first case a single file auction is created. In the second 35 files
(auction00000... auction00034) are created.
In both cases the file or files are loaded to a single database to query.
In most cases the query performance is very similar.
The exception is q09.xq. This appears to be 2 or 3 orders of magnitude
slower against the database created from the split sources.
The actual query result seems to be the same. I have seen the same
performance effect for factors f= 0.2, 0.5, 1 but not the somewhat trival
f=0.
Any idea what is happening here?
Regards
/Andy
--q09.xq---------
let $auction := collection("benchx-db") return
let $ca := $auction/site/closed_auctions/closed_auction return
let
$ei := $auction/site/regions/europe/item
for $p in $auction/site/people/person
let $a :=
for $t in $ca
where $p/@id = $t/buyer/@person
return
let $n := for $t2 in $ei where $t/itemref/@item = $t2/@id return $t2
return <item>{$n/name/text()}</item>
return <person name="{$p/name/text()}">{$a}</person>
