Skip to main content
K
kathiravanm0001
January 14, 2022
Question

Unable to display reports. Problem with huge no of records. How to resolve this

  • January 14, 2022
  • 6 replies
  • 1 view

I have Millions of records in a table, I need to show it in a report but Its not loading in interface. How to resolve this?

6 replies

mikes0011
mikes0011
Brainy
January 14, 2022

What exactly is your report attempting to show?  What data is it trying to access it and how is it being queried onto the interface?  When you say "not loading", what is happening instead?  Can you share some sample code?  The description you've provided so far is vague enough that most of us here won't even be able to guess where to start for assisting you troubleshoot/etc.

The Expression Guru
K
kathiravanm0001Author
January 14, 2022

Hi Mike,

I am trying to show Millions of Records in a Report. Which are account related data. When I open the report, it is take long time to show the data. Through a query entity data got fetched. 

mikes0011
mikes0011
Brainy
January 14, 2022

If you're trying to show millions of records all at once, I'm afraid you're going to find it pretty much not possible, in Appian or pretty much any other software (unless something super expensive and super specialized towards showing massive amounts of data all at once).

The Expression Guru
richardm900458
richardm900458
January 17, 2022

I think , the others try to say: Do you really need to show all data at once?
Could it be enough to show the first hundreds of rows and then use paging to reload the necessary data if you need them?
So you would have thousands of "pages" but its no issue to handle smoothly then. what is the exact scenario to show them at once as no user can ready the simultaneously? 

Terms & ConditionsAccessibility statement