Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 244
  • Last Modified:

out of memmory

hi! regards!

My application is based on VC++5.0 with back end as Ms-access 97
database. While accessing records from database from the application
MS-ACCESS 97 is giving 'out of memmory' because of too much records.

After deletion of those records, the application works smoothly.

but i need to have lot of records. Any fine tuning is required.
if so, kindly suggest me. Advance thanks!
0
sunraj
Asked:
sunraj
1 Solution
 
raybCommented:
You'll probably need to provide more information...
I don't have any idea which database access model you are using, i.e. DAO, ODBC, ADO, but from the information that you've provided, I would suspect that you may be using a cursor type which is sucking up the memory by fetching too many rows at a time.
0
 
wyy_cqCommented:
Change the DB Engine . =)

an other way :
select the record out and put them into file.
you may select a part of records every time.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now