Memory work load problems with finsql.exe

ironluc
ironluc Member Posts: 11
edited 2009-10-20 in NAV/Navision Classic Client
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?

Comments

  • kapamarou
    kapamarou Member Posts: 1,152
    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
    Slawek_Guzek Member Posts: 1,690
    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
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03

Categories