Share
ReportHi Team,
Our organization recently upgraded to MS Dynamics NAV for account purposes. The system handles sale invoices for distributors/retailers and their respective entries are inserted into GL Entry table. For a month, we have almost 450K records for these users. The system is installed on AWS cloud.
The problem arises when we open chart of account and then click on GL Account for the entries. It almost takes 5-7 min to load data. Once the data is loaded and you scroll 30 records, it again invoke query for fetching data and screen freezes for almost 5-7 minutes. It is getting very difficult to operate the system. The above timings are for the client which is installed on the server itself. If we perform operation on our local system the time ranges from 25-35 minutes.
The NAV server is running on Windows 2008 R2 server with 16 GB RAM capacity. After running SQL profiler and analysis of "G_L Entry" table it seems that the table has unnecessary indexes as well as the GL Account number column is varchar(20).
Could you please suggest some direction what should be taken up to increase the performance?
*This post is locked for comments
All responses (
Answers (
291,280
