Memory Available

[elQuijoteMX]

Is there a way to know how much memory is
still available for my application ?

I'm Writing a program that handles very a big matrix and
I would like to now if there is enough memory to
allocate it.

thanks ...

elQuijoteMX

 

[HughLerwill]

Have you tested it to see what happens if there is not enough memory?

I guess the matrix is in an array, just how big is big and what data type are you using?

 

[elQuijoteMX]

thanks for your interest Hugh!

I have to deal with up to 108000 records of 25 columns. Numeric columns could be single floating, and have some that are dates (as least one) one or two long integer and others are few chars ( < 15).

Until now I´ve been using msflexgrid but I can't pass from 10,000 records I got a out of memory error (not the vberror, the msflexgrid error).

I'm trying to solve this with one of two routes.
Using Arrays of my record type, simply dimensioned in my module.
The other route I'm considering is allocating the info in heap.

Speed is my first concern because i refers to process data that is
organized to be analyzed by a process engineer.

I suppose there are another solutions, maybe having the data in my hard disk in some structure but I think that could be one of my last options ...

What do you suggest...

Thanks ...

elQuijoteMX

 

[JoeAtWork]

I have to deal with up to 108000 records of 25 columns.

Is there any reason you need to have all records loaded at once, instead of working with smaller, more manageable chunks?

Why do they need to be loaded into a grid? No human being could possibly fathom that much information at once.

I think we would need a description of what your procedure must do to give better advice.

 

[elQuijoteMX]

That's correct! I can perfectly handle one month production in tha msflexgrid control that I'm using by now. The problem arises when the God users want to se more than one month. I think I can re-code my application so it can construct the graph directly from my oracle dataset resulting from tha query.

Thanks a lot.

But may question remains unanwered how can I display the available memory to my application: heap, stack, etc., etc.

Thanks again ...

elQuijoteMx

 

[strongm]

If you've got 2Gb or more of memory in your PC then your app has 2 Gb available.

 

[tedsmith]

I presume your data is in some sort of database table. If not, if should be!
You can display any part of a table as quickly as your fingers will type using a simple datagrid connected to a snapshot query.

Provided you have the data indexed properly you can easily find a screen full of records in a table with 60000 rows of 30 columns (2core duo type computer)
When you want to edit a field, change to a dynaset query which takes a little longer or safer still use separate text boxes for input to change the record with an update query & refresh the table.