Knowledge Discovery 25.1
Knowledge Discovery Expert

# Optimize Queries

This section describes some basic steps to look at if the Content component is processing queries slowly.

1. Verify that the query is reproducibly slow by sending it multiple times, and looking at the average duration (rather than the longest or shortest duration).

   If you cannot reproduce the behavior, the most likely cause is system load. In this case, investigate what else was happening during the slow period by referring to your Content log files.

2. In a distributed environment where you are using a DAH to query, identify if the query is slow because of a subset of the child servers, or the DAH itself. Send the queries directly to the child servers to eliminate any overhead that the DAH adds.

3. Disable query parameters one at a time to attempt to narrow down the problem. A single parameter can significantly increase the duration of the query. Similarly, remove single items from the Text or FieldText expressions.

   If changing just one parameter makes a large difference, consider what information this gives you. For example, if it is the `Sort` parameter, consider whether the sort is required, or whether it uses a field that is not optimized. Alternatively, does your search include a broad wildcard term?

The `TermGetInfo` action (with the `Text`parameter set to your query text) gives you some idea of the size of the total term information that Content might have to consider to return the query response.

You can get a more detailed timing analysis of the query by sending the `Query` action with the `TimingAnalysis` parameter set to `True`. This analysis includes the count and time spent accessing the internal indexes.

You can use the Query Speed Analysis tab in the Monitor page of Knowledge Discovery Admin to run queries, analyze the query response speed and view a number of performance statistics. If the server is responding more slowly than expected, you can attempt to improve performance by altering query action and configuration parameters from within the Knowledge Discovery Admin interface. You can also use the Terms tab on the Performance page in the Monitor section of Knowledge Discovery Admin to view information about the frequency and type of terms in your data index, which can affect performance.

Copyright 2024 Open Text
Version 25.1 | Last updated January 2025

Send documentation feedback

Close

Send documentation feedback

To send feedback using your default email client, open an email window.

Otherwise, send your feedback and the information below to MFI-swpdl.idoldocsfeedback@opentext.com.

We appreciate your feedback!

Product: Knowledge Discovery 25.1

Topic Title: Optimize Queries