Delayed Data insertion to Tables

Sbhat

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.

Shedman

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

LOL no that does not take hours

Shedman

DenSter wrote:

LOL no that does not take hours

I'd hope not ... or you would have other major performance issues on your SQL server probably :-k

David_Singleton

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.