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
-
This thread will help you
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.0 -
Also what table is it? Can you date compress the table?0
-
Is a table created for me.
I cant Compress now.0 -
Can you compress later?0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 328 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions