Memory work load problems with finsql.exe

ironluc

We have following problem: The memory work load of finsql.exe at the NAV clients become greater and greater within a short time until an error pops up (not enough memory). We are using the latest build of the NAV 5.0 SP1 client. Is it only a problem of a "bad" application? A central part of the application is using temporary records. We don't want to change it because we had reasons to use temporary records at this module. What can/should we do?

kapamarou

ironluc wrote:

A central part of the application is using temporary records. We don't want to change it because we had reasons to use temporary records at this module.

Can you elaborate more on this? Under which circumstances does the problem occur?

Slawek_Guzek

It could be a memory leak.

Temporary records are stored in client workstation memory. Do you have a clue how many temporary records are stored ? Does your code deletes them ever, or just adds/modifies ?. Perhaps adding CLEAR(temprecvariable) after each temprecvariable.DELETEALL helps.

Another reason (not related to temporary records) could be intensive use of RecordRef type variable.

Slawek