DBXML query execution is slow

[detonator413]

Hi,

I'm evaluating Oxygen DB XML support and trying to run DB XML queries from oXygen and my own Java application. Certain queries take about 1 sec in my Java application, and about 1 minute in oXygen. Are there any common pitfalls?

oXygen ver 11.2

Thanks,
Vyacheslav

[stefan]

Could you please let us know what evaluation type are you using in your Java program (XmlQueryContext.Lazy or XmlQueryContext.Eager) and if changing Edit Scenario->Output->Show As "Sequence" makes a difference or not.
(see also: http://www.oxygenxml.com/doc/ug-oxygen/ ... -view.html)

[detonator413]

Thanks for your reply, Stefan.

In my Java program I'm using typically Lazy evaluation, and in my test case I fetched all data by iterating through XmlResults object. Also I tried Eager evaluation, and the query performed as fast.

In Oxygen I had checkbox "Sequence" enabled. When unchecking it, I still experience the long time execution.

How do you think, could it be because of environment settings? (Although, when creating a DB XML connection I set "Join existing environment")
Any other ideas?

Thanks,
Vyacheslav