Re: Poor perfomance with Spread*** OWC 10 with more than 200 columns

From: Alvin Bruney [MVP] (vapor)
Date: 08/26/04 

Date: Thu, 26 Aug 2004 09:18:18 -0500

No, that is not normal. Can you eliminate the loop as the performance
bottle-neck? Are you up to date on your service packs for IE, windows, and
OWC?
about 1500 rows, with 15 columns will load in about a second according to my
tests. 

-- 
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27***
"markatt" <markatt@fastwebnet.it> wrote in message 
news:456a9c08.0408260208.5b3a9507@posting.google.com...
> We are developping a web application based on SQL Server 8.00 and ASP.
>
> We need to create a Report with OWC Spread*** 10 with 210 columns
> and 60 rows. It needs 7 minutes to be load. That's very sad!!!! The
> html page is 310 kb, so its not so heavy.
>
> We have already created other reports with less number of columns (60
> cols) but much more rows (up to 1200). They need something like 1m 1/2
> to be load on the page.
>
> Is it the number of columns to cause this low performance?
> (The same report with only 60 columns need only 1 minutes to load).
>
> Is there a way to reach more good performance?
>
>
> We are loading the OWC with the HTML Data Param using Response.Write
> to design the html table, reading from a Recordset.
>
>
> This is an example of code we are using to create the OWC for all our
> reports.
>
> <OBJECT id=objMyExcel style="LEFT: 0px; WIDTH: 100%; CURSOR: hand;
> TOP: 0px; HEIGHT: 289px"
> classid="clsid:0002E551-0000-0000-C000-000000000046" style="WIDTH:
> 100%" VIEWASTEXT>
>
> <param name="HTMLData" value="
>
> response.write "<table x:str border='0' cellpadding='0'
> cellspacing='0' width='2879'
> style='border-collapse:collapse;width:2169pt'>"
>
> While Not rs_Rep.EOF
>   Response.Write "<TR>"
>   For intCount = 0 To intTotalColumns
>      arrRowInfo = Split(arrRecordsetInfo(intCount),",",-1,1)
>
>      Response.Write "<TD"
>      Response.Write ">" & Replace(CStr("" &
> rs_Rep(Trim(arrRowInfo(2)))),",",".") & "</TD>"
>
>   next
>   Response.Write "</TR>"
> wend
> response.write "</TABLE>"
>
> Thanks for the help,
> Marco