I've a really huge recordset having lacks of records. For some reasons I've to take all the records into an array (using loop) to do some processing and then put it into a grid.
Now since the recordset is huge the memory is not able to handle the array and giving out errors.
When I set the upper bound of the array manually to almost 18000 to 19000 It works fine. But when the real upper bound of the array is set, then it gives out error and not all records are shown.
The windows also gives out message that says "Your system is low on virtual memory. Windows is increasing the size of your virtual memory paging file. During this process, memory requests for some applications may be denied. For more information, see Help."
I am using an array of datatype 'Variant'
What is an alternative?