Page 1 of 1

DBXML query execution is slow

Posted: Thu Mar 25, 2010 3:40 pm
by 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

Re: DBXML query execution is slow

Posted: Wed Mar 31, 2010 11:58 am
by 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)

Re: DBXML query execution is slow

Posted: Wed Mar 31, 2010 1:44 pm
by 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