In my experience, most interface slowness in Appian comes from inefficient query calls.

My approach is:

1. Start with performance metrics

I go to the Interface Performance view to check what is taking time to load.

In the recent Appian versions, the Query Performance tab is extremely helpful—it clearly shows which queries are slow and why.

2. Identify the common causes

From what I’ve seen, slowness usually comes from:

1. A single query fetching a very large dataset
2. Too many queries being executed in the same interface
3. Query rules being called inside loops or repeated expressions

How I improve performance

Case 1: A single query is slow

I first analyze what data the interface actually needs.

Then I optimize the query by:

1. Selecting only the required fields instead of all fields
2. Reducing the dataset using better filters
3. Using proper batch sizes
4. Adding indexes to database columns that the query filters on

Case 2: Multiple queries in the same interface

I check the dependency between the queries and simplify the flow:

1. Move all query calls to local! variables at the top
2. Avoid executing queries deep inside expressions
3. If one query depends on another (e.g., fetch ID first → use ID to fetch more data), I combine them
4. Either create a database view, or
5. If using synced records, utilize record relationships like: recordType!Customer.relationships.person.fields.emailPromotion

Case 3: Query calls inside a loop

This is never advisable since it causes multiple unnecessary round-trips.

I take the query out of the loop and fetch everything in one go, then loop through the already-fetched data.

After making changes, I always re-run the performance metrics or check the Query Performance tab again to confirm the improvements.