From: Wolfgang <wol...@ex...> - 2009-04-24 07:49:52
|
> What can be wrong if a long running query blocks a simple short one? I start an xquery joining > several long xml docs and then a short one that usually takes just 15ms. The short one gets finished > only when the long one does, even timeouts when the long query does. Can you show us the query? And the indexes you defined? Read-only queries will not lock the db. However, bad queries can block the low-level db files, usually because they need to do a full scan over a huge node set. Defining a range index would help in this case. > I just noticed: Java client says it spends e.g. 10.000ms in compilation and 15ms in execution of the > short query. So where/why does compilation get stuck? Ooops, I never saw a compilation taking that long. The short query was started *after* the long one? Wolfgang |