VB application using Collections

[mkb21]

I have developed VB application using collections in VB. Back- end is mssql server 2005.
The huge amount of data is stored since application is used from more than 4 years.
As the drawback collection limitation data is populating with collections is too slow.

Can you suggest i do we purge data so that collection limitation can be overcome ? Is there any better solution?
How can we avoid speed issue in the application.

We have indexed on table columns as required.

Thanks and In advance

[vb5prgrmr]

Why are you using collections when the recordset is basically a collection in itself?