User Tools

Site Tools


slowness_in_generating_reports

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Last revisionBoth sides next revision
slowness_in_generating_reports [2007/12/10 08:14 (17 years ago)] andrewslowness_in_generating_reports [2013/05/09 11:10 (11 years ago)] kevin
Line 8: Line 8:
 Most reports need to read all related data in your system.  For instance, Inventory reports will read inventory and Customer reports will read all customers.   Most reports need to read all related data in your system.  For instance, Inventory reports will read inventory and Customer reports will read all customers.  
  
-These are expensive lookup in terms of time for the computer to access the database and can be even more expensive if the report is not being run from the server.  +These are expensive lookups in terms of time for the computer to access the database.  These reports can be even more expensive if the report is not being run from the server.  
  
 **Possible causes for slow report generation:** **Possible causes for slow report generation:**
Line 16: Line 16:
 2) Size of data - Large datasets will take a longer amount of time to run.  There is no way to delete database records from System Five as they are interdependent.  In the case of a large dataset you will have to take note of the time needed to run the report and budget that time each day. 2) Size of data - Large datasets will take a longer amount of time to run.  There is no way to delete database records from System Five as they are interdependent.  In the case of a large dataset you will have to take note of the time needed to run the report and budget that time each day.
  
-3) Slow network connection - The speed of your network directly impacts the speed of running the report as each record in your reports will require multiple communication requests across your network.  Large downloads from the internet or computer-to-computer on your network will cause slowness.  Ensure that no user on the network is moving large amounts of data during the report generation. +3) [[Slow network connection]] - The speed of your network directly impacts the speed of running the report as each record in your reports will require multiple communication requests across your network.  Large downloads from the internet or computer-to-computer on your network will cause slowness.  Ensure that no user on the network is moving large amounts of data during the report.
- +
-\\ +
-\\ +
-\\ +
----- +
-Author: arose\\ +
-Editor: arose\\ +
-Last Edited: 10-Dec-2007 +
slowness_in_generating_reports.txt · Last modified: 2021/08/02 06:26 (3 years ago) by anemenzo