We have a business requirement where we have around 50 rows per batch size + N number of columns. N columns can be 1 till N number which is determined by the file they upload or the data they entry.So each row has a value which is mapped to a column and we determine if its 1 or 0 based on a simple click. We hold these mappings in the database so each particular field is one entry in the database. By clicking the toggle in the Right grid we set the value to 1 or 0.
Problem #1 since we have huge amount of data depending on the columns every click take a lot of time. (I'm only saving that particular field to a cdt and saving in the process model).
Problem #2 I tried to leverage the load by placing a local variable with the icon documents but it didn't improve.
Problem #3 we can't lower the batch size but due to business requirements they require to show at least 50 rows if you have 50 columns that makes 2500 icons.
Any suggestions are appreciated find an attached image so you get the idea.
Discussion posts and replies are publicly visible
Hi Jose Cavazos Issue with using editable grids with batch size of 50 and nearly 10 columns is that with every change to the cell or any other field on the interface. all the fields initialized in grid will be executed in the above mentined case 500 Imagefields will have to execute on each cell update.
Hi @Jose Cavazos Just a quick question here, what function/rule are you using to decide, which image to render conditionally on the Grid ? for example: displayvalue(), choose() , Decision Object etc..
The reason why i am asking this because, when you are dealing with huge amount of data, you should try to avoid complex logic / multiple conditional statements such as if() while rendering each row of the Grid, as this will be evaluated for every single row.
Hi Jose,
Do you have many with() variables? It's possible that the with() variable reevaluations are slowing down your interface. Otherwise, have you looked into the performance view?