Poor performance with OWC Spreadsheet

[bogdanutz]

Hi. For several days now i'm having a big problem.
I am using the owc spreadsheet control 10.0. I have created a C#
written wrapper for the control and i am feeding xml data to the
control . My application needs a very large quantity of data (the xml
data reaches like 40M).
The problem appears when i say spreadsheet.XMLData = "my xml": it
takes from 25-30 sec and more to load. And even worse is when i am
trying to pull data from the control to save it.

Is there a problem with the control or it just won't work with that
quantity of data?
I presume there is some sort of xml validation . Is there a way to
customize this?
Can i use another control that works better ?

Many thanks.

 

[Alvin Bruney [MVP]]

Well, for starters, loading 40Megs of anything, anywhere will incur a
performance penalty. Your time quote does not seem unreasonable to me. If
you want a lighter option, convert the xml to csv before you load. You will
find that the file size will be much smaller than 40 meg.

 

[bogdanutz]

CSV is not an option as i need xml formatted data for other stuff too
and converting to csv just for loading the spreadsheet it would be
even more difficult : loading an xpathdocument to parse
with xslt (from such a large xml) would take a long time and quite some
memory.
Indeed the 25-30 sec to load this is not that long but not everybody
works on a computer as fast as mine (that was my mistake : i tested on a
computer with less performance and the time goes to about 2-3 min wich is
unacceptable).

Is there a way to figure out what is taking so long? (I have a lot of
formulas but
they are quite simple)

Well, for starters, loading 40Megs of anything, anywhere will incur a
performance penalty. Your time quote does not seem unreasonable to me. If
you want a lighter option, convert the xml to csv before you load. You will
find that the file size will be much smaller than 40 meg.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Hi. For several days now i'm having a big problem.
I am using the owc spreadsheet control 10.0. I have created a C#
written wrapper for the control and i am feeding xml data to the
control . My application needs a very large quantity of data (the xml
data reaches like 40M).
The problem appears when i say spreadsheet.XMLData = "my xml": it
takes from 25-30 sec and more to load. And even worse is when i am
trying to pull data from the control to save it.

Is there a problem with the control or it just won't work with that
quantity of data?
I presume there is some sort of xml validation . Is there a way to
customize this?
Can i use another control that works better ?

Many thanks.

 

[Alvin Bruney [MVP]]

From my tests, the bulk of the time was spent in actually rendering the data
in the control. If you could page, or reduce the initial view of data, that
would drop the time significantly.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

CSV is not an option as i need xml formatted data for other stuff too
and converting to csv just for loading the spreadsheet it would be
even more difficult : loading an xpathdocument to parse
with xslt (from such a large xml) would take a long time and quite some
memory.
Indeed the 25-30 sec to load this is not that long but not everybody
works on a computer as fast as mine (that was my mistake : i tested on a
computer with less performance and the time goes to about 2-3 min wich is
unacceptable).

Is there a way to figure out what is taking so long? (I have a lot of
formulas but
they are quite simple)

Well, for starters, loading 40Megs of anything, anywhere will incur a
performance penalty. Your time quote does not seem unreasonable to me. If
you want a lighter option, convert the xml to csv before you load. You will
find that the file size will be much smaller than 40 meg.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Hi. For several days now i'm having a big problem.
I am using the owc spreadsheet control 10.0. I have created a C#
written wrapper for the control and i am feeding xml data to the
control . My application needs a very large quantity of data (the xml
data reaches like 40M).
The problem appears when i say spreadsheet.XMLData = "my xml": it
takes from 25-30 sec and more to load. And even worse is when i am
trying to pull data from the control to save it.

Is there a problem with the control or it just won't work with that
quantity of data?
I presume there is some sort of xml validation . Is there a way to
customize this?
Can i use another control that works better ?

Many thanks.