Display of Records

[million]

QUESTION:
We are looking for alternative solutions to display records in VB either using
a) ARRAYS
b) Grid
c) Spread Control.

Our VB application calls RPC in CICS region, which process data and creates a VSAM dataset.The volume of data that is processed is HUGE say ranges from 7 to 20 million records. Then the VSAM dataset is read and data is sent to VB and displays the content on the screen.

Currently we are using GRID control and displays 2000 records. As per our knowledge Grid control as a limitation of 2000 records.

We would like to display the huge volume of data in small segments say 1000 records at a time, if yes what approach we should follow to resolve our problem?

What is the capacity of an array in VB is there a default limitation?
If the array size based on the Memory of the machine?

If an array can HOLD million records and then display 1000 records at a time --- i.e page 1, next 1000 records page 2. next page 3 so like this how many Grids can we have? Is there a limitation of the GRID? meaning 7 - 8 million records can run into PAGES.
Can we swap 'NEXT' or 'PREVIOUS' as we do in HOTMAIL.

Any suggestion, help will be appreciated.

Regards
Sumam, Pius and Pavana

 

[swilliams]

If you want the to display the records, an array will not help you - this is only used as memory storage.
If you want to display 1000 records at a time, use a grid and have Next / Back buttons. On click of either of these buttons, reset the recordsource of the grid to select the next / previous 1000 records and refresh the grid. It means changing the sql in the RecordSource property of the grid, but when ou are dealing with such a large set of data you have to find work arounds.
Are you really expecting the user to page through 7 million+ records??
Would it be easier to produce summary info??

Simon