by PeterHarmes » Wed May 18, 2011 3:47 pm
Hi,
I inserted the memory flush into my code and weirdly it seemed to make things worse, so I put the call into a less used routine and it did seem to help.
However, the main change i made was with SQLRDD - I modified my code to use Sr_SetFilter instead of SET FILTER in a certain routine and that speeded up my system and kept it running at a reasonable speed - the memory flush released memory and didnt seem to effect the performance. Before, my customers said that when my app reached 50M and above, they noticed the difference and a drop in performance.
I am going to my customers next week so I can see the performance and compare it to before. (They are in Holland and I'm based in England)
Hope that helps
Pete