Web page with Chart component opens to slow

Question

0.00/5 (No votes)

See more:

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

Oshtri Deka

Updated 30-Nov-12 2:02am

v2

Add a Solution

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.

ZurdoDev 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.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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