Hi All,

I'm working on a Windows service written in VP6.0 that has a number of SQL statements that return a large amount of data into cursors. When the cursors are created they take up a large amount of memory ( in some cases up to 800mb ) which isn't a problem, but when they are closed the memory is not being freed up.

I've tried RELEASE ALL, CLEAR ALL, CLEAR MEMORY, CLOSE DATABASES ALL, but the memory usage remains high. The only way to free the memory seems to be to restart the service.

The service is running on a W2K SP3 Terminal Server with 2GB of RAM, 20GB harddrive and an Intel 2.80GHZ Xeon processor. The data being accessed comes from VFP DBFs.

Does anyone have any ideas why memory would not be released after closing a Cursor?

Thanks,
Gavin