Record Performance

There was a hotfix released in December for issues if you were query a high number or records, see forum.appian.com/.../Hotfixes.html (for Appian 7.11 > 16.3)

Please confirm your version of Appian and that the latest Hotfix is applied?

Yes Sally, we have this hotfix installed in all our sites.. still do see slower editable grid performance for all record types - DB based and expression based (4 -5 secs for 20 records display)

@saravanana as hotfix already installed but still facing slowness in editable grid, as per my understanding, performance also depends on, how many rows you are pulling under editable grid, as less number of rows we pull, performance will be that great, better to pull less rows at a time and use paging

Application is fetching only 25 records, we changed to 10 records.. do see same performance .. only less than 1/2 seconds difference..

@saravanana does record contains large set of columns, because in this case also the size gets increase and effects the performance

are the table/s indexed? indexing will improve performance while reading but write time may grow up. If possible could you please share expression please

@Alok.. We have 5 to 9 columns range. There is no difference even reduce number of columns, even for one column..
@ravitejavj, Table only have 100 records for MySQL DB based records. and expression based record returns only 25 records (service takes only 1 sec, but record rendering takes 9-10 secs_..

Can you attach the code for interface as well as query entity which fetches the data, which will be rendered into editable grid

Alok, There is no interface.. it product driven feature - Record list (DB or expression based) If you want I create support case and give access to our instance..

There is a huge difference between DB vs Expression based record. Which one are you referring to here? - In order to test the performance, create the expression in a rules editor and check the performance. Make sure that the paging info is same as that in the Record to ensure its a like to like testing scenario.

Another thing to ensure is to make sure that your integration are performing as expected. CHeck the Database log to check for its performance metrics.