DBXML query execution is slow

Having trouble installing <oXygen/>? Got a bug to report? Post it all here.
detonator413
Posts: 2
Joined: Thu Mar 25, 2010 3:35 pm

DBXML query execution is slow

Post by detonator413 » Thu Mar 25, 2010 3:40 pm

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
Posts: 45
Joined: Wed Jan 08, 2003 9:43 am
Contact:

Re: DBXML query execution is slow

Post by stefan » Wed Mar 31, 2010 11:58 am

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
Posts: 2
Joined: Thu Mar 25, 2010 3:35 pm

Re: DBXML query execution is slow

Post by detonator413 » Wed Mar 31, 2010 1:44 pm

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

Post Reply