Hi All,
I have a grid(using record data) that its making my interface take about 10-15 seconds to load- it has 32 columns and the data is very big.
Any suggestions to improve performance ?
thanks in advance
Discussion posts and replies are publicly visible
We need more details about your grid. Did you try to just query the same data as in the grid using a!queryRecordType()? How long does it take?
whats the difference between using a!recordData() which is what I'm currently using compared to a!queryRecordType()?
I would try to understand where the root cause is. Does the query take long, or does the rendering of the grid take most of the time.
The grid does all sorts of internal magic you cannot look into. Separating things makes it more transparent.
I don't think is the data query actually, when you see these values what can you deduce ?
OK. Do you do any additional queries inside your grid columns? Or is there a record action field showing actions that have security or visibility configured?
Yes! actually there are a few columns that call different expressions rules for the displaying data
Yeah, well, calling queries in a loop calls for trouble.
so even after removing those columns in the meantime - the page takes about 8-10 seconds to load.
Did you try to check the "Query Performance" tab in the designer's monitoring section?
You mean the tab in the same interface? like from where I send the previous images?
https://docs.appian.com/suite/help/24.3/monitoring_view.html#query-performance