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.
Discussion posts and replies are publicly visible
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