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

From: markatt (markatt_at_fastwebnet.it)
Date: 08/26/04 

Date: 26 Aug 2004 03:08:14 -0700

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

Loading