Question

How to significantly speed up the performance of Reports ?

  • 26 April 2024
  • 1 reply
  • 39 views

Userlevel 3
Badge

Any suggstions ?


1 reply

Userlevel 7
Badge +4

@skumar98 Are these custom reports or stock reports?

Typically the best options are to reduce the size of the data set or run the report during off hours if possible.

Additionally, if there are lots of joins you could try to combine some of them into a custom field or SQL view and then use this instead of some of the tables, though this can’t always work.

Make sure all joins are correct and data links are as accurate and efficient as possible to reduce extra and if there are subreports, make sure these are also running as efficiently as possible

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved