Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Job Planning Lines Page very slow switching between fields and lines
rishi255
Member Posts: 1
Hello,
We use the Jobs module and the job planning lines table is very big. We have about 50 jobs and each job can have up to 100,000 job planning lines.
The issue we are running into is when users are trying to create new job planning lines or edit fields in existing lines, it takes a almost 4 minutes to switch to the next field or line and its getting longer everyday since more and more job planning lines are being created. The job planning lines page has been customized a bit (new fields and logic)
This is only happening on the jobs module. All other pages don't seem to be giving this issue. We recently upgraded our servers and hardware. RAM is more than enough (probably around 24 GB).
Would updating indexing procedures help with this? Or other options?
Please advise.
Thank you
We use the Jobs module and the job planning lines table is very big. We have about 50 jobs and each job can have up to 100,000 job planning lines.
The issue we are running into is when users are trying to create new job planning lines or edit fields in existing lines, it takes a almost 4 minutes to switch to the next field or line and its getting longer everyday since more and more job planning lines are being created. The job planning lines page has been customized a bit (new fields and logic)
This is only happening on the jobs module. All other pages don't seem to be giving this issue. We recently upgraded our servers and hardware. RAM is more than enough (probably around 24 GB).
Would updating indexing procedures help with this? Or other options?
Please advise.
Thank you
0