September 2008 - Posts
Recently we completed a very complex upgrade from version 3.10 to 5.0. This project was done together with Liberty Grove Software in the USA. The company involved has a period where they are extremely busy. In that period the performance was terrible. It was holding up the business. We examined the database and decided to do a full upgrade to 5.0 and migrate them to SQL 2005. The most difficult part was Item Tracking. This was highly customised in their situation. I've learned a lot during this...
That's the question. It's about two years ago since I started working with Liberty Grove Software, a certified upgrade service center. I've helped them establish a european office. Since that time we've done about 12 upgrades together. Upgrades has always been a problem in the Navision world. The methodology is there and clear. The problem is not the methodology but the nature of Navision. Navision is a very flexible development environment which easily allows bad development. Since...
Hi all, Hynek at SQL Perform asked me to publish something about a myth being spread by some Microsoft specialists. MYTH: "Make sure that the order of the fields used for filtering is the same as order of these fields in the key." REALITY: Certainly the order of the filtering does NOT matter, nor in Classic, nor SQL Server. The driver does issue the filters according to the key anyway (because on classic it narrows the index tree...). See an example below: ItemLedgerEntry.SETCURRENTKEY...