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.