Solved

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

Posted on 2008-10-17
3
2,560 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 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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
Let’s face it: one of the reasons your organization chose a SaaS solution (whether Microsoft Dynamics 365, Netsuite or SAP) is that it is subscription-based. The upkeep is done. Or so you think.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

635 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