Large data sets Not Charting

[ctuttle48]

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?

[Pallav]

You might be using dataXML method. For such number of data records, you need to necessarily use dataURL method.

[AlvaroG]

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 April 12, 2007 by Guest