Doubt in Navision Key Creation while Restoring Backup

sancse540
Member Posts: 2
Dear All,
This is santhosh Kumar working as a Tachnical Cosultant for Navision ERP.I have one doubt in Navision Database Table Key Creation ,while restoring the Navision Backup into Database i observed one thing that from 1-50 % of key creation taking more time when comapre to 51- 60 % of key creation. so i want to know why it is happening like that & what is the Back ground Process of table key creation & restoration.
Database Details,
Type : Navision Navtive.
Version : Navision 3.7 (same thing i observed in nav2009 restoration also).
Thanks in Advance.
Regards,
Santhosh Kumar
This is santhosh Kumar working as a Tachnical Cosultant for Navision ERP.I have one doubt in Navision Database Table Key Creation ,while restoring the Navision Backup into Database i observed one thing that from 1-50 % of key creation taking more time when comapre to 51- 60 % of key creation. so i want to know why it is happening like that & what is the Back ground Process of table key creation & restoration.
Database Details,
Type : Navision Navtive.
Version : Navision 3.7 (same thing i observed in nav2009 restoration also).
Thanks in Advance.
Regards,
Santhosh Kumar
0
Comments
-
The keys are created in object number order.
Bigger tables have bigger indexes that take longer to create.
The blue bar is a percentage of the number of tables not database size, table size or some other guess.
The biggest tables mostly have small object numbers (17, 21, 32, 254, 5802)Robert de Bath
TVision Technology Ltd0
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
- 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
- 320 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