[Exist-development] very slow updates

[Evgeny G. <gaz...@gm...>]

Hi!

"update insert" is very slow now!
since don't know, new structurial index may be?

so next query:

declare function local:process($row, $set){
update insert $row into $set
};
(# exist:batch-transaction #){
for $x in ("altnames","doma","flat","socrbase","kladr","street")
let $uri := xmldb:store("/store/eskk/kladr",concat($x, ".xml"), element {$x} {})
let $set := doc($uri)/*
return dbf:import(concat("/home/evgeny/workspace/solenoid/app/local/tmp/eskk/src/kladr/",$x,".dbf"),
"cp866", util:function(xs:QName("local:process"), 2), $set)
}

works in 1000 times slowly then query:

declare function local:process($row, $set){
let $x := xmldb:store($set, (), $row)
return ()
};
for $x in ("altnames","doma","flat","socrbase","kladr","street")
let $set := xmldb:create-collection("/store/eskk/kladr", $x)
return dbf:import(concat("/home/evgeny/workspace/solenoid/app/local/tmp/eskk/src/kladr/",$x,".dbf"),
"cp866", util:function(xs:QName("local:process"), 2), $set)

half year ago both queries were worked ~ equal.

----------
Evgeny