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