|
From: Ferdinando A. <na...@am...> - 2011-03-25 10:06:53
|
Hi Peter > In fact there may be a problem. I attach an example sheet. [...] During this I > observe that more and more memory is used by excel.exe. Escaping the > loop, the number of objects is 5 (seems ok). If I delete the yield curve > object (by computing cell b12) the memory allocated before is released. > > I am aware that one should not recompute the yield curve object if quotes > are updated, but rather rely on the implemented observer pattern. However > the behaviour above should not be as it is, should it? yes, I think you've found a genuine memory leak. Eric ? > However, if I recompute e.g. cell a2 (the first rate helper) and a9 > afterwards, I see the same effect, i.e. the yield curve object seems to > have received a notification from the recomputed rate helper object? would you elaborate a little more here. I mean there might be a lot going on under the surface (and undocumented :-), but before discovering my cards I would need to understand what exactly do you do in this second case. Namely before recomputing a2 do you setValue ? What do you mean by "the yield curve object seems to have received a notification from the recomputed rate helper object" later ciao -- Nando |