Hi Dojo,
Currently, the driver is deleting a part of the total rows at once, which is taking too much time and causing an RTE to pop up. We have already logged the times and the amount of rows to be deleted:
As you saw, the amount of rows to be deleted is over 50,000.
The way we are doing it is:
protocol.DeleteRow(Parameter.Cmqamdschannels.tablePid, keysToRemove);
My question is if there is another way to delete rows so it won't stay a lot of time doing it.
Thanks.
Hi Sergio,
There isn't any faster way (at least that I can think of) to remove keys other than repopulating the table or clearing all keys like Edib or Michiel has mentioned.
if the intention is to avoid going into RTE when deleting rows, maybe you can delete them in smaller chunks to avoid the DeleteRow from taking too long. example deleting in groups of 5000 rows.
Hello Frans,
I already tried that, and even with 5000 rows it is taking more than 8 minutes
I see that the initial attempt took about 15mins so there is definitely an improvement with the smaller amount of keys.
If I am not mistaken the SLProtocol/SLNet calls should not exceed 15K rows at a single time. so could you try adjusting try increasing/decreasing the keys to see if you can get better results.
if that still does not help, maybe check with software
Hi Sergio,
since you are removing all rows, would protocol.FillArray with empty array speed things up?