I am working in Cache Objectscript where I need to process around 0.2 million data.
I am executing SQL query through "%Library.ResultSet"
Set status = tsRSet.Execute(<param 1>,<param2>)
Is there any limitation of the above code when the number of records the query is fetching is high.
If the query returns 0.5 million to 1 million record will my code work properly or it may break due to high volume of data.
I have 4 GB RAM and 2 GB global buffer in my production system.
Any information regarding the matter would be greatly appreciated.