Solved

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

Posted on 2008-10-17
3
2,498 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
  • 2
3 Comments
 
LVL 4

Assisted Solution

by:AndersHedegaard
AndersHedegaard earned 500 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 500 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Messaging apps are amazing tools with the power to do a lot of good, but the truth is the process of collaborating with coworkers requires relationships established through meaningful communication - the kind of communication that only happens face-…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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.

776 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