ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   RAM Question (https://www.excelbanter.com/excel-programming/371307-ram-question.html)

Jason Zischke

RAM Question
 
Hi all,

I had a program set up that was slow and used at times up to 350 meg or RAM,
so i spilt up the files to build up speed and to hopfully reduce RAM which
worked however the RAM at times still at times pushes to the near 300s. Any
ideas on how I can reduce my RAM usage without sacrificing speed?

Jason

NickHK

RAM Question
 
Jason,
Depends what you are doing.
A bit more detail would help ?

NickHK

"Jason Zischke" wrote in message
...
Hi all,

I had a program set up that was slow and used at times up to 350 meg or

RAM,
so i spilt up the files to build up speed and to hopfully reduce RAM which
worked however the RAM at times still at times pushes to the near 300s.

Any
ideas on how I can reduce my RAM usage without sacrificing speed?

Jason




Jason Zischke

RAM Question
 
Hi NickHK

to my one program there is about 10 different files that are loaded from
time to time depending on what the user is doing so that I didn't have
unessesary calculations, form or macros loaded and the resting RAM (when the
program is just up but not really doing anything) the RAM is about 180meg but
when the user wants to print multiple views it climbs to about 300 meg.

Jason

"NickHK" wrote:

Jason,
Depends what you are doing.
A bit more detail would help ?

NickHK

"Jason Zischke" wrote in message
...
Hi all,

I had a program set up that was slow and used at times up to 350 meg or

RAM,
so i spilt up the files to build up speed and to hopfully reduce RAM which
worked however the RAM at times still at times pushes to the near 300s.

Any
ideas on how I can reduce my RAM usage without sacrificing speed?

Jason





NickHK

RAM Question
 
Jason,
If the amount of RAM is a concern, see
http://www.decisionmodels.com/memlimitsc.htm

You can also these worksheet functions to see when it changes
=INFO("memused")
=INFO("memavail")
Can't say how reliable their values are.

NickHK

"Jason Zischke" wrote in message
...
Hi NickHK

to my one program there is about 10 different files that are loaded from
time to time depending on what the user is doing so that I didn't have
unessesary calculations, form or macros loaded and the resting RAM (when

the
program is just up but not really doing anything) the RAM is about 180meg

but
when the user wants to print multiple views it climbs to about 300 meg.

Jason

"NickHK" wrote:

Jason,
Depends what you are doing.
A bit more detail would help ?

NickHK

"Jason Zischke" wrote in

message
...
Hi all,

I had a program set up that was slow and used at times up to 350 meg

or
RAM,
so i spilt up the files to build up speed and to hopfully reduce RAM

which
worked however the RAM at times still at times pushes to the near

300s.
Any
ideas on how I can reduce my RAM usage without sacrificing speed?

Jason








All times are GMT +1. The time now is 08:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com