Hello,
I have a multiple row block. Each row has a check box - nondatabase item.
when checkbox is checked the value is set to Y and when not it is N. when I click insert button in my form, it loops through all the records and inserts data where checkbox is Y. this works fine but when the block has huge no of rows say 1000 and I have checked only one or few rows, then performance is bad as it loops through each row lookin for Y and then insert and this takes longer time.
Is there any better way to optimize the insert? is there any way to loop through only selected checkbox something like using array to make the insert faster. if yes a code sample is appreciated.
thanks in advance.