M
markatt
We are developping a web application based on SQL Server 8.00 and ASP.
We need to create a Report with OWC Spreadsheet 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
We need to create a Report with OWC Spreadsheet 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