MSCharts with large amount of data is slow.
-
Hi there guys. Background: Im currently developing a website that displays data retrieved from MS SQL Server on a chart with MS Charts. The data stored in MS SQL Server table is a temperature measurement taken every second. Every thing works fine. As long as i dont exceed 1 hour of data points. Well up to 4 hours sometimes work as well. But as sson as I increase the range of datapoints to display on the chart(using fastline series) it takes forever and even sometimes times out.(Im using Microsoft Visual Basic 2008(C#) ASP.NET and MS Charts) Question: 1.Is there another chart application that handles large amounts of data beter. There is several available but I cant say which will handle large data quantities beter. (and this is for a University final year project so the budget is very tight) 2.Is there a way to maybe speed up MS charts. 3.And finally I even tried to filter my SQL query to return only every 60th row which I dont mind on say a 12 hour chart. But I cant seem to find any solution to return every nth row that works. Thanks in advance. Any help will be much appreciated. Cobus
-
Hi there guys. Background: Im currently developing a website that displays data retrieved from MS SQL Server on a chart with MS Charts. The data stored in MS SQL Server table is a temperature measurement taken every second. Every thing works fine. As long as i dont exceed 1 hour of data points. Well up to 4 hours sometimes work as well. But as sson as I increase the range of datapoints to display on the chart(using fastline series) it takes forever and even sometimes times out.(Im using Microsoft Visual Basic 2008(C#) ASP.NET and MS Charts) Question: 1.Is there another chart application that handles large amounts of data beter. There is several available but I cant say which will handle large data quantities beter. (and this is for a University final year project so the budget is very tight) 2.Is there a way to maybe speed up MS charts. 3.And finally I even tried to filter my SQL query to return only every 60th row which I dont mind on say a 12 hour chart. But I cant seem to find any solution to return every nth row that works. Thanks in advance. Any help will be much appreciated. Cobus
you need to optimize your sql queries.
Everything Is Possible!
-
you need to optimize your sql queries.
Everything Is Possible!
Suresh Dayma wrote:
you need to optimize your sql queries.
Thanx. I figured that would be the best. Building a custom query to select only every 60th row. Could just not find a good solution to such a query. Current solution that ive got that is working is creating an empty data table and then using a for statement to select a specific row and appending it to the datatable with the row identifier as the for counter multiplied by 60 or whatever the case may be until the spesified date or time is reached. Thus creating a table with the relevant time span but only selected values.(thus painting the chart is much faster due to less values) This works fine just feels cumbersome and sloppy. Well thanks so far.