There is a fair bit written about memory leaks due to failure to release BigText or automation objects, but has anyone had experience with the NAV WS memory footprint growing out of control in other cases?
We recently reworked our web shop to use several NAV web services. The web services run on a small server that has 4GB of memory, and the WS process has been growing until it consumes all that memory then becoming unusably slow. Currently, it takes about a day to consume all available memory, but we are in an off-peak season. Adding memory is easy enough, but I don't know how much is enough and cannot find any reason for the excessive memory usage. We've reviewed the code, to ensure that all CREATEd objects also get CLEARed.
We ran some tests with a "simple" web service that just created a row with junk data in it in a small custom table, and were able to get it to grow to about 55MB before it stabilized. We tried similarly with inserting basic sales header records, and it grew out of bounds and finally crashed (after hours).
Does anyone know of things (other than missing CLEAR commands) that can be wrong with NAV code to cause the WS to grow excessively? Is there some caching happening, and if so, is there a setting to limit it?
0