Web Development

Ask something
Discussion Locked

OUT OF MEMORY?

0 helpful
7 replies

by nixer 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Here is the break down:

I am using ADO w/ stored queries to access a Microsoft Database which contains over 2 million records. I have created indexes in the database on the fields in which I use to search.(Check Number, Amount, Date)

I have incorporated a MSFlexGrid control which displays any duplicate records. When I do a search on let's say check number it returns all information and populates the grid just fine. When I try to search for an amount(field) and the program must retrieve a lot of data and populate the grid it gives me an out of memory error?

What in the heck can I do about that?

7 replies

by miss kitty

We're running a program called MemTurbo. It automatically runs and retrieves any unused memory. When you run these queries, it stores so much in memory and when the query finishes, it doesn't release it unless you go out and reboot. MemTurbo is cheap. Only 19.99 and we use it on all the PC's that run Access and our SQL software.
Cathy
covcat@riverstonegrp.com

by beltira

Another program to do this is called MaxMem from AnalogX. It is a great program, uses very little memory and its free. Really free, no adds or anything. You can locate it at www.analogx.com

by kgreenwood

FlexGrid Control is limited to 350,000 total cells...Break the data up into smaller chunks, users normally only want 20-50 records on the screen at one time

This discussion is closed to new replies.