Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2636
  • Last Modified:

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

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
dougshepard
Asked:
dougshepard
  • 2
2 Solutions
 
AndersHedegaardCommented:
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
 
AndersHedegaardCommented:
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
 
dougshepardAuthor Commented:
Nice!  Thanks!

Doug
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now