Hi,
I have created on dashboard application using devexpress and MVC.
On loading the dashboard it takes nearly 10 minutes.
SO I created data extracts to compress sql data source and assigned it to dashboard data source.
On updating the dashboard I have written one method in global.asax.cs.
There are 22 lakhs records fetching to my server..
While retrieving that records it is taking more time.
How should i increase performance of the website by reducing the burden on the server?
Here I am using java script.
Please suggest me a solution.
Thank you.
What I have tried:
protected void UpdateExtract(string dashboardId)
{
try
{
using (Dashboard newDashboard = new Dashboard())
{
using(Dashboard Dashboard1=new Dashboard())
{
newDashboard.LoadFromXml(Server.MapPath(string.Format(@"~/App_Data/Dashboards/{0}.xml", dashboardId)));
Dashboard1.LoadFromXml(Server.MapPath(string.Format(@"~/App_Data/Dashboards/SQL/{0}.xml", dashboardId)));
var dataSour = Dashboard1.DataSources.OfType<DashboardSqlDataSource>().ToArray();
foreach (DashboardSqlDataSource datr in dataSour)
{
datr.Fill();
}
var dataSources = newDashboard.DataSources.OfType<DashboardExtractDataSource>().ToArray();
foreach (DashboardExtractDataSource dataSource in dataSources)
{
dataSource.ExtractSourceOptions.DataSource = dataSour[0];
dataSource.UpdateExtractFile();
}
}
}
}
catch (Exception Ex) { }
}