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
|
