Click here to Skip to main content
12,452,213 members (55,729 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: ASP.NET .NET .NET4
Hi!

I have simple web application which shows results of analysis in charts (chart control which comes with VS2010).
SQL queries responsible for fetching data used by charta usually finish in less than three seconds, but for page creation and opening it takes at least 60 seconds.

One chart is fast line and other is column. Both have three series (A,B and C=A+B).
I use SqlDataSources and on chart page there is virtually no code.


How can I improve performance?
Posted 8-Aug-12 1:00am
Updated 30-Nov-12 2:02am
v2
Comments
Kenneth Haugland 8-Aug-12 7:02am
   
Could we see the code anyway? It is difficult to know, and another question is how much data are you showing? 10 1000 10000 ?
Oshtri Deka 8-Aug-12 7:14am
   
No code, sqlDataSources call stored procedures, page was meant to be for presentation only.
It rarely returns more than 35k rows. Schema is datetime2, int, int, int
and date int, int, int. Integers values are up to 3k.
Kenneth Haugland 8-Aug-12 7:33am
   
Rearly more than 35k... Thats a lot, you should section the plot somewhat.
ryanb31 30-Nov-12 8:09am
   
Are you plotting the 35k rows? Charts are created on the server and are just bitmaps sent to the client. But if you are trying to chart that many rows, it will be slow.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160826.1 | Last Updated 30 Nov 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100