performance issue on view data

Question

Hi Team, 
 I got an performance issue while fetching data from the view. 
 I will explain my scenario, i used a join query on 2 tables while fetching data from view, its around 18lakhs(around 6 month of data) of records approximately count will increase day to day. 
 Based on the data, displayed columns reports. 
 for every minute, this count will increase, based on the count chart reports will updated. that means, every time while loading or hitting the page view will fetch the data from the database will display charts in UI. 
 
 But actually, we got an performance issue on database, because count will increase. 
 
 Can we have any other approach for displaying to endures. 
 
 Thanks in advance. 
 Regards, 
 Bhanu Prakash.

sandeepd · Answer

Hi , 
 If I am correct you are only displaying count in Chart, then use Stored Proc and only get count details from DB. And even if you want to Use fetched data in grid or table then also I can say SP is the best option you have. 
 For huge data count you will always face performance issue for huge data. 
 
 Thanks, Sandeep

Dave Lewis · Answer

It sounds like you're querying within a with() block, which would make you run the query again every single time the user does anything on the form. You want to limit your requeries as much as you possibly can, maybe querying once on load() and if you need to once on some control designed to refresh the data. 
 If you need to requery on a continual basis, you might want to look at upgrading to 19.2 and seeing if the a!localVariables can give you a better option to limit the number of requeries to an acceptable level. 
 If you are only gathering totals, sums, averages, aggregate data, you definitely want to take the SP route and use your DBMS for your data aggregation. 
 Just general guideline would be "Give Appian the minimum amount of data possible."