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 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
I'm in 23.2 , dont have that feature.
OK. Then I suggest to reduce the grid to a single row without any kind of additional logic or query in the column value. If the grid still takes that long, the problem is the query. You will then have to analyze that.
BTW, I assume that you have reasonable paging in place and do not try to load hundreds or thousands of rows into the grid.