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