Why is querying slow? - HxGN SDx - Update 63 - Administration & Configuration

Administration and Configuration of HxGN SDx

Language
English
Product
HxGN SDx
Search by Category
Administration & Configuration
SmartPlant Foundation / SDx Version
10

HxGN SDx is a data repository that can handle millions of objects and relationships. Many systems like this perform perfectly well, but when systems are not well configured or are left to grow without maintenance and tuning, performance can degrade over time. The first indication that something is wrong with a system is often an increase in the amount of time necessary to query for documents and data.

To perform a query, the user enters the query or quick find criteria. The client then builds the query request, which is sent to the server. The server processes the requests, queries the database, and packages the results to return to the client, where they are processed and displayed in the list view. Many steps in this process can cause poor performance, so this is a case for a general analysis of the system.

SHARED Tip When users are running queries with a large set of results, remember to configure quick finds and queries to use paging to improve performance.

If the configuration changes implemented do not improve the performance of the system, further analysis is required to determine the problem.