Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How does a Navision flowfield work so much faster than a SQL sum command?

Posted on 2008-10-17
3
Medium Priority
?
2,603 Views
Last Modified: 2013-11-23
In Microsoft Dynamics NAV (Navision) a flowfield shows the sum of thousand or millions of lines from other tables almost instantly, but when I try to sum the same data using a SQL Query SUM it takes hours... why?

Thanks

Doug
0
Comment
Question by:dougshepard
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 4

Assisted Solution

by:AndersHedegaard
AndersHedegaard earned 2000 total points
ID: 22746040
The flowfield sums are calculated during the insert of records. A separat set of records is maintained with the sums already calculated. The Navision client therefore only has to find a few records whereas SQL SUM has to find and sum all the records.
0
 
LVL 4

Accepted Solution

by:
AndersHedegaard earned 2000 total points
ID: 22746061
You can actually access the same sums as they are maintained in regular tables. In a Navision SQL database there are a number of tables with only numbers. Those numbers reference table, field and index numbers in Navision. With the help of a Navision developer you can find out which to use.
0
 

Author Comment

by:dougshepard
ID: 22759944
Nice!  Thanks!

Doug
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question