SSDN - Xquery Performance Issue

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

sud rall

Subject: Xquery Performance Issue
Author: sud rall
Date: 07 Jul 2016 03:01 PM

Hi All,
We are using complex Xquery with many data field validation which make us to see slowness in xquery performance. Is there a way to improve the performance ????

Ivan Pedruzzi

Subject: Xquery Performance Issue
Author: Ivan Pedruzzi
Date: 07 Jul 2016 03:17 PM

Which XQuery processor are you using?

If you send the xquery code and an example of input we will take a look
stylussupport@ivitechnologies.com

Ivan Pedruzzi
Stylus Studio Team

sud rall

Subject: Xquery Performance Issue
Author: sud rall
Date: 07 Jul 2016 07:52 PM
Originally Posted: 07 Jul 2016 07:15 PM

Hi Thanks for quick response. I dont know what you mean by processor??? we are using .xqy format file and these Xquery files has 3 different xml schema using one xquery file to match to one xml schema. which is creating a performance issue.

Ivan Pedruzzi

Subject: Xquery Performance Issue
Author: Ivan Pedruzzi
Date: 07 Jul 2016 08:07 PM

The processor is the software that executes the XQuery.

Do you run your queries in Stylus Studio?
If you do you can see which processor you are suing in the scenario dialog.

If you are not using Stylus Studio or DataDirect XQuery, we cannot help you.

If you don't share your XQuery code with us we cannot help.

Ivan Pedruzzi
Stylus Studio Team

sud rall

Subject: Xquery Performance Issue
Author: sud rall
Date: 08 Jul 2016 05:00 PM

We are using DataDirect Xquery processor.

sud rall

Subject: Xquery Performance Issue
Author: sud rall
Date: 08 Jul 2016 05:06 PM

I cant share my Xquery Code in the forum... Is there away we can get temporary license for DataDirect. As we are using DataDirect xquery Processor.

sud rall

Subject: Xquery Performance Issue
Author: sud rall
Date: 08 Jul 2016 05:54 PM
Originally Posted: 08 Jul 2016 05:12 PM

I cant share my Xquery Code in the forum... Is there away Ican get temporary license for DataDirect. & we are using DataDirect xquery Processor.

When we try to convert to java code it says DataDirect expired.

Ivan Pedruzzi

Subject: Xquery Performance Issue
Author: Ivan Pedruzzi
Date: 08 Jul 2016 05:47 PM

Sudhir,

I provided an email address for sending your code privately to us, see message above.

For the purpose of testing your query you can use Stylus Studio.
It seems that you have evaluated Stylus Studio last month.
Have you purchase a license?

Ivan Pedruzzi
Stylus Studio Team

sud rall

Subject: Xquery Performance Issue
Author: sud rall
Date: 08 Jul 2016 07:17 PM
Originally Posted: 08 Jul 2016 06:16 PM

HI Thanks for quick response.Here is the problem we are facing in Xquery..

We have 3 input data source which has 3 Xquerys in one ABC.xqy file & we are check from which input data source the file is coming execute related query but issue is it complies other 2 data source xquery which making the process slow.. we are using IF statement to check the condition.. is there any away we can enhance the xquery code not to compiling other 2 queries when they are not need.

DataSourceIssue(1).docx

DataSourceIssue.docx
DataSource Issue

Ivan Pedruzzi

Subject: Xquery Performance Issue
Author: Ivan Pedruzzi
Date: 10 Jul 2016 07:11 AM

If your query takes long to prepare (compile), your Java code should crate XQPreparedExpression once then call Execute query.

Ivan Pedruzzi
Stylus Studio Team

sud rall

Subject: Xquery Performance Issue
Author: sud rall
Date: 11 Jul 2016 06:53 PM
Originally Posted: 11 Jul 2016 01:13 PM

HI,
As showed in the site i converted the stylus studio code to Java code and try to run in Eclipse ...... here is the error which shows up.

Exception in thread "main" javax.xml.xquery.XQException: [DataDirect][XQuery]The evaluation period for DataDirect XQuery has expired. Please contact DataDirect Technologies to purchase a valid license.

How to get temporary license for DataDirect ?????

Did you had a chance to see the attached document.

DataSourceIssue(2).docx

sud rall

Subject: Xquery Performance Issue
Author: sud rall
Date: 12 Jul 2016 01:18 PM

Hi,
how can i see the log file generated by Stylus studio while running xquery.. is this feature available for license version ???

Ivan Pedruzzi

Subject: Xquery Performance Issue
Author: Ivan Pedruzzi
Date: 12 Jul 2016 06:44 PM

Please do no pollute the forum with the same question.

Stylus Studio does not create a log file when executing DataDirect XQuery. Execution's errors are captured in the Output Window.

Ivan Pedruzzi
Stylus Studio Team

sud rall

Subject: Xquery Performance Issue
Author: sud rall
Date: 12 Jul 2016 06:44 PM

HI Ivan when we try to execute the Xquery using xml pipeline we are getting below error

Java built-in Validation Starting (Xalan Java 2.7.0).
Loading schema file:///file.xsd
file:///TESTOU~1.XML:1,39: (Fatal Error) Content is not allowed in prolog.
There was an error during the parsing of TESTOU~1.XML
Reason = Content is not allowed in prolog.
Java built-in Validation completed with errors.
Execution reached STOP node 'Stop': Error

Ivan Pedruzzi

Subject: Xquery Performance Issue
Author: Ivan Pedruzzi
Date: 13 Jul 2016 08:45 PM

This was solved offline

Ivan Pedruzzi
Stylus Studio Team

sud rall

Subject: Xquery Performance Issue
Author: sud rall
Date: 14 Jul 2016 01:50 PM

HI Iavan, Thanks for response.. is there anyway i can get temporary license for DATADIRECT.jar ???

Ivan Pedruzzi

Subject: Xquery Performance Issue
Author: Ivan Pedruzzi
Date: 14 Jul 2016 03:03 PM

As I stated In our phone call, DataDirect XQuery evaluation is part of your Stylus Studio X16 evaluation

Look in

c:\Program Files
-Stylus Studio X16 XML Enterprise Suite 64 bit
--Components
---DataDirect XQuery
----lib

You can check the expiration date in Stylus Studio under
Tools->Options->Components->DataDirect XQuery->License Manager

Ivan Pedruzzi
Stylus Studio Team

sud rall

Subject: Xquery Performance Issue
Author: sud rall
Date: 15 Jul 2016 08:52 PM

Hi Ivan,
I dont see any file name or folder name with license Manager ???

Ivan Pedruzzi

Subject: Xquery Performance Issue
Author: Ivan Pedruzzi
Date: 15 Jul 2016 08:58 PM

In the Stylus Studio UI see screenshot attached

Ivan Pedruzzi
Stylus Studio Team

sud rall

Subject: Xquery Performance Issue
Author: sud rall
Date: 19 Jul 2016 03:17 PM

How to upgrade the license key for DataDirect and how i can set key for the jar????

Is it one time purchase ???

Ivan Pedruzzi

Subject: Xquery Performance Issue
Author: Ivan Pedruzzi
Date: 19 Jul 2016 03:40 PM

To update the DataDirect license key you can use Stylus Studio license manager as shown in the previous screenshot. Make sure to start Stylus Studio as administrator.

Once you have purchased the DataDirect XQuery license you will obtain a control code which you will input in the license manager. Stylus Studio will ask to restart. Restart Stylus Studio as administrator and the DataDirect jar library will be updated with the new license.

You will then be able to take the jar files from <stylus folder>\Components\DataDirect XQuery\lib and use it in your Java application.

DataDirect XQuery is licensed per data source per CPU core. It is a one time fee.
For pricing contact stylusstudio@ivitechnologies.com

Support and maintenance are 21% of you license cost.

Ivan Pedruzzi
Stylus Studio Team

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.