Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K 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
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 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
optimizing tables using an automatic procedure
gri
Member Posts: 87
hi there
we run into a little problem here regarding performance.
we have a customer in retail industry and we had to setup something like 95 or more native navision attain databases. one for each store, that is. version 3.6 for now.
after a few months in production and probably because we are using data director from landsteinar to send data from one database to another, the use of specific tables, in fact customer and items tables, became very, very time consuming, although the tabels are not extremelly large by navision standards (something like 100-200 Mb)
we've found out that using the OPTIMIZE function from database information/tables/optimize on regular basis we can dramatically improve performance.
the issue is that we cannot expect our customer it support team to open in every given day ALL the 95 (and still counting) databases in order to optimize the tables and we hope that there is a way of automating or scheduling this procedure.
i hope i gave enough details, please help me solve this.
thank you in advance
we run into a little problem here regarding performance.
we have a customer in retail industry and we had to setup something like 95 or more native navision attain databases. one for each store, that is. version 3.6 for now.
after a few months in production and probably because we are using data director from landsteinar to send data from one database to another, the use of specific tables, in fact customer and items tables, became very, very time consuming, although the tabels are not extremelly large by navision standards (something like 100-200 Mb)
we've found out that using the OPTIMIZE function from database information/tables/optimize on regular basis we can dramatically improve performance.
the issue is that we cannot expect our customer it support team to open in every given day ALL the 95 (and still counting) databases in order to optimize the tables and we hope that there is a way of automating or scheduling this procedure.
i hope i gave enough details, please help me solve this.
thank you in advance
0
Comments
" When you receive your ExpandIT License file it gives you as legal entity the right to install and use one (1) instance of the software."
and, because i need to maintain not one, but one hundred databases, the total cost of the licences will probably be sky high.
anyway, the good news it's that it can be done and, therefore, will shall look further into this subject.
thank you for your quick reply. it was very usefull.