Memory/ressources leaks with a windows service

[Zugg]

Hello

I have a windows service using DOA 4.0.4.0

when my service starts a treatment with a lot of oracle access, the service's memory and virtual memory increase but when the treatment is finished the memory is not freed.

so i install the new version 4.0.6.2 and now in the end of the treatment my memory is freed but my memory increase a lot during the process.

How can i disable this increase during my process ?? close the session or do another treatment to freed partially my memory ??

Cordially...

Hugues

 

[Marco Kalter]

To free memory during processing, you can call TOracleQuery.Close or TOracleDataSet.Close after you are done with it. If possible, you can also set TOracleDataSet.UniDirectional to True to minimize memory overhead.

 

[Zugg]

thanks for your answer

normally query and dataset are closed but i'll verify it and i'll try Unidirectionnal property...

cordially...

--
Zugg