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.

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

Sorry to answer my own question, but I found a solution: Instead of using the datagridview to show only the newest 10 entries I changed my SQL Query which will fill my datatable to:

SELECT TOP 10 Column1,Column2
FROM Table_Name
ORDER BY Column1 DESC

This result is then the 10 most recent entries in the table. Without the DESC keyword the first 10 entries will be displayed Thank you in any case.

Good day all. This is the first time I ask a question here, but have been using codeproject for some time now. Great site - Good work! Im doing a C# windows forms application that reads data from Windows Sql Server Express and then displays the data from a specific table in a datagridview (im using bindingsource). This is no problem. The problem is my table is quite large more than a thousand rows. Currently all the data displays at one time with vertical scroll bars to scroll down. But I would like to only display a fixed number of rows, say the last 10 entries. Is this at all possible. Hope this question has not been asked before. Searched through a bunch of forums and websites and could not get the right question with an answer. Thanks in advance. Cobus