Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Visual Basic
Expertise: Beginner
Feb 18, 2000

ADO and Large Tables

Question:
I have several MS Access97 database tables that are larger than 120 MB. When I use ADO to open the entire table it seems to try to load the table into memory, this crashes the machine it is running on. Is there anyway to limit the amount of memory used by ADO?

Answer:
If you don't need all the data back at the same time, you might want to try using the PageSize/PageCount properties of a static recordset. If you open your recordset as adOpenStatic, you can set the PageSize property to be the number of records you want back at a time.

The PageCount property will then be populated with the number of pages (full or partial) that are in the recordset. You can then use the AbsolutePage property to jump immediately to a particular page. This method is much more efficient when it comes to large recordsets and large databases.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap