Delayed Data insertion to Tables

Sbhat
Sbhat Member Posts: 301
edited 2011-02-12 in NAV/Navision Classic Client
Hi -

I am running SQL 2005 64Bit Service pack 3 with NAV 5.0SP1, when i posted resource journal i noticed that the data was not written to Resource ledger entry table right away, it took couple of hours for the data to show in Resource ledger entry. Has anyone encountered this problem? Is there anything that needs to be done at SQL end?

Any help is appreciated.

Thanks
SB.

Comments

  • Shedman
    Shedman Member Posts: 194
    AFAIK SQL Server saves all transactions in the Transaction Log before writing it to the data files. Sounds like there is some lag in that process.
  • DenSter
    DenSter Member Posts: 8,307
    LOL no that does not take hours :mrgreen:
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • Shedman
    Shedman Member Posts: 194
    DenSter wrote:
    LOL no that does not take hours :mrgreen:
    I'd hope not ... or you would have other major performance issues on your SQL server probably :-k
  • David_Singleton
    David_Singleton Member Posts: 5,479
    Sbhat wrote:
    Hi -

    I am running SQL 2005 64Bit Service pack 3 with NAV 5.0SP1, when i posted resource journal i noticed that the data was not written to Resource ledger entry table right away, it took couple of hours for the data to show in Resource ledger entry. Has anyone encountered this problem? Is there anything that needs to be done at SQL end?

    Any help is appreciated.

    Thanks
    SB.

    This is an issue and you need to resolve it.
    David Singleton

Categories