General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Releasing memory after running a SQL statement
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only