XQuery Profiler

Stylus Studio®'s XQuery Profiler (illustrated below — click to enlarge) XQuery Profiler allows you to benchmark any XQuery expression, and it helps you locate and eliminate performance bottlenecks for maximum XQuery performance.. A new online video demonstrates the use of the Stylus Studio® XQuery Profiler. This tutorial covers an overview of its main features, including an example with a sample profiling report.

XQuery Profiler

Generate Detailed Performance Profile of XQuery Code

First, enable the Stylus Studio® XQuery Profiler from within the XQuery editor. Click on the scenario properties button (the "..." icon) and select the "Profiling Options" tab, as illustrated here:

Configure XQuery Performance Profile

You can customize various aspects of the XQuery profiling report, including the following options:

  • Show call tree of XQuery execution times
  • Show execution time by XQuery expression
  • Show log of step-by-step XQuery functions
  • Limiting the XQuery trace to a specified number of instructions
  • Limiting the XQuery trace to a specified level (or depth)
  • Optionally save the raw XQuery profiling data to an XML file

XQuery Performance Profiler Backmapping

Once you've selected your XQuery profiling options, simply run your XQuery expression by pressing the "Execute XQuery" button or by typing the F5 key. A detailed XQuery performance profile is displayed in the XQuery output preview window. Backmapping is a helpful feature involving the seamless integration of of the Stylus Studio® XQuery Profiler's report, and your original XQuery source code, to help you identify and eliminate performance bottlenecks. Simply click on any line in the XQuery profiler's report, and Stylus Studio® will automatically highlight the corresponding line of XQuery code in the XQuery editing window. In the example illustrated below, Stylus Studio® has determined that 72.40% of the time taken to execute an XQuery is taken up by a single node - by clicking on the report, Stylus Studio® highlights the expensive conditional looping block inside of an XQuery FLWOR Block.

Save the XQuery Performance Analysis as HTML

From within the XQuery Output Preview Window, click on the Save-As button to save a copy of the XQuery profiling report as HTML using the default stylesheet provided with Stylus Studio®, illustrated below. Since the performance profiling data is also available as XML, its easy to create customized report layouts.

XQuery Performance Analysis

Side-by-Side Benchmarking of Different XQuery Processors

So what if you're not using the default Stylus Studio® XQuery processor in your run-time environment? Not to worry! Stylus Studio® also supports XQuery profiling with other leading XQuery processing components, including the Java-based Saxon XQuery Processor, illustrated below. Support for multiple XQuery processors in the XQuery Profiler also alows you to create side-by-side comparison benchmarks of running the same XQuery expression using different processors, or testing modified versions of an XQuery expression against the original.

Saxon Performance

If your application has the need for speed, Stylus Studio® X16 XML Enterprise Suite XQuery profiler is a must-have! Profilers are important tools for analyzing XQuery performance — they providing a detailed trace of execution times, allowing you to benchmark XSLT or XQuery against different processors. This valuable insight into how to optimize the underlying XSLT or XQuery code. As XML applications become increasingly complex, Stylus Studio® XQuery profiler along with our XSLT Profiler are essential - especially if you plan to deploy XSLT or XQuery code to mission-critical systems. Stop the guesswork, or throwing money at costly hardware based XML processors and start improving XML application performance today.

PURCHASE STYLUS STUDIO ONLINE TODAY!!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Try STYLUS XQuery Profiler

Download a free trial of our award-winning XQuery profiling tools!

Top 10 XQuery Trends

Read about the top 10 XQuery Trends and how they will impact change the way enterprise software applications are built.

What's New for Stylus Studio® X16?

New XQuery & Web Services Tools, Support for MySQL, PostgreSQL, HL7 EDI, Microsoft .NET Code Generation and much more!

Ask Someone You Know

Does your company use Stylus Studio? Do your competitors? Engineers from over 100,000 leading companies use Stylus Studio, and now you can ask someone from your own organization about their experiences using Stylus Studio.

XQuery Help and Discussion Forum

Learn about XQuery development at the SSDN's new XQuery Help and Discussion Forum

 
Free Stylus Studio XML Training: