Skip to Main Content
AVEVA™ PI System™ Feedback Portal

Welcome to our feedback site!


We created this site to hear your enhancement ideas, suggestions and feedback about AVEVA products and services. All of the feedback you share here is monitored and reviewed by the AVEVA product managers.

To start, take a look at the ideas in the list below and VOTE for your favorite ideas submitted by other users. POST your own idea if it hasn’t been suggested yet. Include COMMENTS and share relevant business case details that will help our product team get more information on the suggestion. Please note that your ideas and comments are visible to all other users.


This page is for feedback specifically for AVEVA PI System. For links to our other feedback portals, please see the tab RESOURCES below.

Status No status
Created by Guest
Created on Apr 17, 2023

Reduce Search Performance Variability when identical filters are used but return result sets of varying size

Currently, the AF Server will produce identical parameterized SQL queries for 2 AF Searches that search for the same object type with the same filters.


On a large system, performing a search that produces a small result set can cause SQL Server to cache a query plan that is only suitable for small result sets. This can cause performance degradation if larger searches are performed by the same user with the same filter set.


An implementation to avoid this Parameter Sniffing problem for AF Searches could make searching the system more consistent in terms of performance.

  • Attach files