Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.7K 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
- 326 Dynamics CRM
- 110 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 994 SQL General
- 384 SQL Performance
- 34 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Filter Problem
poloba
Member Posts: 15
I have Navision 4 in SQL Option. One Table is very very big (10GB only the table). My problem is the filters of the users. The Users make filters over fields that not are keys.
The find is very very very slow.
The problem is when the filter is aply, the server dead with this query and the others users dead too.
My question is:
¿Any have a Idea for resolve this?
¿Can I deny filters for only one table o form?
The find is very very very slow.
The problem is when the filter is aply, the server dead with this query and the others users dead too.
My question is:
¿Any have a Idea for resolve this?
¿Can I deny filters for only one table o form?
0
Comments
http://www.mibuso.com/forum/viewtopic.php?t=13556&highlight=onaftergetrecord
Basically OnAfterGetRecord on the FORM You need check if there is a key for the field and if there isn't remove the filters from the REC.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
I cant Compress now.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n