Sign in to follow this  
ctuttle48

Large data sets Not Charting

Recommended Posts

I have a sample charting web page written in asp.net 2005.

The page uses a storeprocedure to "create" the XML data stream.

It works great with 10-25 records. (with animation on or off)

When I change the store procedure to return 500 records the line chart never renders.

Can fusion charts render 100-500 records?

What is the best way to accomplish this?

Share this post


Link to post
Share on other sites

Hi Chad

 

 

 

your problem it's in the stored procedure, i guess that you are using a Varchar(N) variable to generate the XML String and with 10-25 records the chart it's work but when you want to diplay 100 records the VARCHAR(N) variable is not too large to store the complete XML String.

 

 

 

i use the same method as you... an example...

 


[b]	DECLARE @XML_GRAFICO   nVARCHAR(max)

DECLARE @XML_CATEGORIA nVARCHAR(max)

DECLARE @XML_DATASET_1 nVARCHAR(max)

DECLARE @XML_DATASET_2 nVARCHAR(max)

DECLARE @XML_DATASET_3 nVARCHAR(max)

DECLARE @XML_DATASET_4 nVARCHAR(max)[/b]



DECLARE @CAMBIO_HORARIO INT

SET @CAMBIO_HORARIO = ( SELECT CONVERT( INT , dbo.FN_CONFIGURACION('CAMBIO_HORARIO') ) )

SET @XML_GRAFICO = ''

SET @XML_GRAFICO = @XML_GRAFICO + '
SET @XML_GRAFICO = @XML_GRAFICO + 'bgColor=' + '''' + 'f8f8f8' + '''' + ' '

SET @XML_GRAFICO = @XML_GRAFICO + 'canvasBorderThickness=' + '''' + '1' + '''' + ' '

 

 

 

as you can see the '@XML_GRAFICO' variable it is 'nVARCHAR(max)' type, this type let you store a large amount of data and i think that is your problem... your variable maybe it's a VARCHAR(4000)???

 

 

 

bye.

Edited by Guest

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this