I am new to webMethods. I have 2 questions regarding best practices about document list.
What is best way to query data that will return thousands of records? I have tried for 50.000 records. I am using JDBC adapter Select right now, and it creates result in large document list. I find that query those data would take long time, i guess it is because creating ‘large document list’ process.
Then, in the middle of flow service, to save memory, i want to drop this query document list result. I find it take long time to drop too. Is there any best way to drop large document list?
Thank you in advance.