-
February 12th, 2010, 06:56 AM
#1
VB application using Collections
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
-
February 12th, 2010, 08:25 AM
#2
Re: VB application using Collections
Why are you using collections when the recordset is basically a collection in itself?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|