Skip to content
GigaSpaces Logo GigaSpaces Logo
  • Products
    • InsightEdge Portfolio
      • Smart Cache
      • Smart ODS
      • Smart Augmented Transactions
    • GigaSpaces Cloud
  • Roles
    • Architects
    • CXOs
    • Product Teams
  • Solutions
    • Industry Solutions
      • Financial Services
      • Insurance
      • Retail and eCommerce
      • Telecommunications
      • Transportations
    • Technical Solutions
      • Operational BI
      • Mainframe & AS/400 Modernization
      • In Memory Data Grid
      • Transactional and Analytical Processing (HTAP)
      • Hybrid Cloud Data Fabric
      • Multi-Tiered Storage
      • Kubernetes Deployment
      • Streaming Analytics for Stateful Apps
  • Customers
  • Company
    • About GigaSpaces
    • Customers
    • Partners
    • Support & Services
      • University
      • Services
      • Support
    • News
    • Contact Us
    • Careers
  • Resources
    • Webinars
    • Blog
    • Demos
    • Solution Briefs & Whitepapers
    • Case Studies
    • Benchmarks
    • ROI Calculators
    • Analyst Reports
    • eBooks
    • Technical Documentation
  • Contact Us
  • Try Free

Space Query Plan for XAP

Subscribe to our blog!

Subscribe for Updates
Close
Back

Space Query Plan for XAP

Moll Aharon October 24, 2016
4 minutes read

XAP is being developed tirelessly and we are pleased to introduce one of our newest features, the Space Query plan for XAP.

It brings with it a plethora of information that can be extracted from queries run from within the live environment itself.

The Space Query plan helps stop developers falling into the pitfall of focusing only on results and not performance. A key part of application management today, it should not be neglected.

What Is Space Query Plan?
Just producing an application that allows access to the right information at the right time for users isn’t enough. The real benefit comes from speed and efficiency of these types of system interrogations, and with Space Query we are giving our customers a way to improve on both of these through the use of Explain Plan reporting. Monitoring of performance in a live environment, without placing excess strain on the system itself, is an invaluable tool when looking to drive application and cost efficiencies.

Explain Plan is not a new feature as anyone in the DB world knows; however, by introducing this type of query management into our IMC system the possibilities for developers have grown immeasurably.


What Does This Mean and How Can I Utilize It?
Inefficient queries can seriously slow down the execution of any application, no matter how fast the computing environment is. With Space Query now being available in XAP, these types of queries can be targeted and amended, complementing our super-fast processing power with cleaner, more responsive applications.

Currently this is available to run against extended match or compound queries and each type will yield a slightly different set of information. It can be used to help answer questions such as which index has been used and how many entries have been scanned to get the appropriate result, or to identify which specific conditions were checked against.

To run this command you simply need to follow three easy steps:

  1. Use .withExplainPlan() to indicate a query should be executed with an explain plan
  2. Execute the query as usual
  3. Use .getExplainPlan() to get the result, and print it

For example:
SQLQuery query = new SQLQuery(MyPojo.class, “price > 1000”)
.withExplainPlan();
Object result = gigaSpace.read(query);
System.out.println(query.getExplainPlan());

What you will end up with is a report detailing steps the query has run, query parse trees, indexing information, and scanning information. All of these are presented in an easy-to-read format that can then be analyzed to find out where a query may be putting unnecessary load onto an application.

Let’s take an extended match query for example and see what this type of report might look like:
Here you can clearly see each stage of the query, where the data has been pulled from, how many partitions and entries were scanned, and then the exact steps taken within the query tree.

As you can imagine, this type of information is invaluable and allows the focus to shift from output to performance within the production environment. Introduction of this into In-Memory Computing is opening doors and keeping products ahead of the competition when combined with the incredible processing power it already offers.

Monitoring of this information can provide easy insight into whether your application may be querying too many entries or without proper indexing within the space for example. By amending or eradicating these types of queries as appropriate, or changing indexes of areas for example, operational performance can be greatly increased without the need for more computing power.

Overall, the introduction of this feature is a great way to drive system productivity, increase customer satisfaction, and get far more out of your IMC solution for even less.

CATEGORIES

  • XAP
Moll Aharon

All Posts (3)

YOU MAY ALSO LIKE

June 20, 2017

Why We Need a New…
5 minutes read

September 18, 2008

GigaSpaces XAP – Product Overview
1 minutes read

June 24, 2014

GigaSpaces is excited to announce…
4 minutes read
  • Copied to clipboard

PRODUCTS, SOLUTIONS & ROLES

  • Products
  • InsightEdge Portfolio
    • Smart Cache
    • Smart ODS
    • Smart Augmented Transactions
  • GigaSpaces Cloud
  • Roles
  • Architects
  • CXOs
  • Product Teams
  • Solutions
  • Industry
    • Financial Services
    • Insurance
    • Retail and eCommerce
    • Telecommunications
    • Transportation
  • Technical
    • Operational BI
    • Mainframe & AS/400 Modernization
    • In Memory Data Grid
    • HTAP
    • Hybrid Cloud Data Fabric
    • Multi-Tiered Storage
    • Kubernetes Deployment
    • Streaming Analytics for Stateful Apps

RESOURCES

  • Resource Hub
  • Webinars
  • Blogs
  • Demos
  • Solution Briefs & Whitepapers
  • Case Studies
  • Benchmarks
  • ROI Calculators
  • Analyst Reports
  • eBooks
  • Technical Documentation
  • Featured Case Studies
  • Mainframe Offload with Groupe PSA
  • Digital Transformation with Avanza Bank
  • High Peak Handling with PriceRunner
  • Optimizing Business Communications with Avaya

COMPANY

  • About
  • Customers
  • Management
  • Board Members
  • Investors
  • News
  • Events
  • Careers
  • Contact Us
  • Book A Demo
  • Try GigaSpaces For Free
  • Partners
  • OEM Partners
  • System Integrators
  • Value Added Resellers
  • Technology Partners
  • Support & Services
  • University
  • Services
  • Support
Copyright © GigaSpaces 2021 All rights reserved | Privacy Policy
LinkedInTwitterFacebookYouTube

Contact Us