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 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.