Slow fob import

Cem_Karaer

Hi all,

I have a table (Value Entry) that has lots of data of several companies. Total size of the tables is nearly 10 GB. I make minor developments to this table; for instance making code changes or property changes. But saving those kind of developments takes so much time. I know that adding new field to a table takes time because new field in every row is updated for preventing null values. But why does it take so much time to make non-adding-field developments? Is there a way to shorten the saving time?

The problem also rises up when importing fob of such a table. Importing is necessary because test database and live database are to be synchronized.

rdebath

There are several possible reasons, what version of Navision, including the build number are you using.

Marije_Brummel

Yes, I remember 5 SP 1 having an issue with vSift indexes being rebuilt every time you'ld change something to the table, even if there was no change to the fields.

If I remember correctly this bug was solved.

Also when using 2009 with the servicetier it takes longer to generate the C# code.

Cem_Karaer

Navision 5.01 TR (Unfortunately I couldn't find the build number)
SQL Server 2008 x64
Windows Server 2003 R2 x64

Cem_Karaer

Mark Brummel wrote:

Yes, I remember 5 SP 1 having an issue with vSift indexes being rebuilt every time you'ld change something to the table, even if there was no change to the fields.

If I remember correctly this bug was solved.

Also when using 2009 with the servicetier it takes longer to generate the C# code.

Thank you Mark,

Is it possible to post the link of the hotfix?

Marije_Brummel

There is a cumulative update available for 5SP1. I would try that.

More details on waldo's blog. www.waldo.be

kriki

With this link, you don't need to search for the list: http://dynamicsuser.net/blogs/waldo/archive/2009/09/17/platform-updates-overview-3-70-b-nav2009-sp1.aspx

And also Microsoft followed Waldo's example:
https://mbs.microsoft.com/Cms/Templates/document/General.aspx?NRMODE=Published&NRNODEGUID={6200B9F0-C1DD-419B-81F7-0F9CC0E65B7D}&NRORIGINALURL=/partnersource/support/selfsupport/hottopics/NAV500SP1PlatformHotfixOverview&NRCACHEHINT=Guest&wa=wsignin1.0

But you need to login.

kapamarou

cemkaraer wrote:

Navision 5.01 TR (Unfortunately I couldn't find the build number)

If you go to Help -> and Double click on the version you will see a build number.

Cem_Karaer

kriki wrote:

With this link, you don't need to search for the list: http://dynamicsuser.net/blogs/waldo/archive/2009/09/17/platform-updates-overview-3-70-b-nav2009-sp1.aspx

And also Microsoft followed Waldo's example:
https://mbs.microsoft.com/Cms/Templates/document/General.aspx?NRMODE=Published&NRNODEGUID={6200B9F0-C1DD-419B-81F7-0F9CC0E65B7D}&NRORIGINALURL=/partnersource/support/selfsupport/hottopics/NAV500SP1PlatformHotfixOverview&NRCACHEHINT=Guest&wa=wsignin1.0

But you need to login.

Thank you very much for the link!

DenSter

cemkaraer wrote:

Unfortunately I couldn't find the build number

Hi Cem, it's easy to find the build number. Click the Help menu and select 'About'. Then, on the form that pops up, doubleclick on the version number. This pops up a dialog box with the build number.

Another way is to browse to the installation folder, and hover your mouse over the executable. This should show the file properties of the executable file, and the build number is part of the 'File Version' property. For instance, my finsql.exe file says 'File Version: 6.0.92626.0', which stands for NAV 2009 SP1 (although the 'SP1' part is not very clear there), build number 92626.

Cem_Karaer

kapamarou and Denster, thank you both for the explanation.

Here is the build number:

---

Microsoft Dynamics NAV

---

Build 26084

---

OK

---