i decreased the list from 333k to 100k and it works now along with sorting function. but as my bots run it will increase again in size. what would you guys recommend?
Hope that really answered your problem. Can also use the "Select Records" command, change the Table to the second one and add any filters you need. This will return all records in a list and using the Foreach will get the job done.
