agarwaldvk
02-05-2007, 05:20 PM
Hi Everybody
This is my first post on this forum, so please bear with me if I haven't got everything right. In time, I will!
I have written a fairly large Excel based application - it actually has grown to become as big as it has now over a three (3) year period.
As the application goes through its cycle of processing record after record (row after row), it seems to slow down.
My understanding for this to be happening is that there is apparently some memory leak somewhere which I am not able to pinpoint. As a concequence of which, less and less memory is available to the program to do what it is supposed to be doing thereby has to go the disk more and more frequently - slowing the processing.
Is there a way to find out if there are any memory leaks and if yes, how do I go about do so?
Whilst there are some global variables, not a lot though and some global dynamic arrays (I erase these global dynamic arrays at the end of the process anyway), my understanding is that this couldn't be the contributing factor since if that were to be the case, then that would happen right at the start, wouldn't it?
Any suggestions, please?
Best regards
Deepak Agarwal
This is my first post on this forum, so please bear with me if I haven't got everything right. In time, I will!
I have written a fairly large Excel based application - it actually has grown to become as big as it has now over a three (3) year period.
As the application goes through its cycle of processing record after record (row after row), it seems to slow down.
My understanding for this to be happening is that there is apparently some memory leak somewhere which I am not able to pinpoint. As a concequence of which, less and less memory is available to the program to do what it is supposed to be doing thereby has to go the disk more and more frequently - slowing the processing.
Is there a way to find out if there are any memory leaks and if yes, how do I go about do so?
Whilst there are some global variables, not a lot though and some global dynamic arrays (I erase these global dynamic arrays at the end of the process anyway), my understanding is that this couldn't be the contributing factor since if that were to be the case, then that would happen right at the start, wouldn't it?
Any suggestions, please?
Best regards
Deepak Agarwal