Question

Record Query Performance monitoring

Forum|Forum|2 years ago
March 20, 2024
13 replies
0 views

Some of the queryRecordTypes are working slow for us in prod. I am trying to monitor the performance and it has something 'performanceView.breadcrumb.recordQuery' highlighted. What does that mean and what part of the query/record it points to? Any idea

Also, Appian do recommend using queryRecordType to get the data from the related records too but when I have filters and logical expressions applied to them they are performing slow.

davidj137213

The problem with the records is that when you use user filters , and each one of them executes a rule when populated, the performance can be affected, because the filters are evaluated on each user interaction.

Remove some user filters and make a test please in order to identify is the problem is related with that point

R

radhikam530794Author

Sorry by filters I meant query filters.

davidj137213

IN that case, check if the fields in the database that you use in the query filters are indexed.

As with user filters, try removing query Filters in order to find which one is causing the problem. Probaly that field won't be indexed

stefanhelzle0001

Is this whole setup using synced records? If yes, there is no need to try to optimize anything in the database.

R

radhikam530794Author

Yes all the records are synced records. That's what I was wondering synced records are built to boost record performance and fast usage. But somehow they are slow for our users.

stefanhelzle0001

Well, what kind of queries are you doing? And how is the implementation? Using runtime custom record fields will probably not help. Filters with dynamic options will not help.

Sign up

Login with SSO

Login to the community

Login with SSO