Why is my webpage so slow?

[JNeave]

Using

SQL Server 2000
IIS 2000
IE5.0
InterDev 6

Running IIS and SQLS on a dual P3 800.

IE running on a P4 1.7 over a 100baseT LAN.

And only I (the developer) am hitting this web page.

On the front page there are several pull downs with quite a few items in them (100's), now...

Running the queries that retrieve the data in these pull downs takes milliseconds, transmitting the data over the LAN takes milliseconds.

So why does it take 20 seconds to display the page?

It's because IIS CHUGS through the ASP scripts.

Example

Select aa Location<BR>
<%=createBoundComboBox(TableName, DataField, DisplayField, width, blankEntry, etc.)%>

These library function are all in an .inc file.
This paticular function creates a huge string, looping through an ADO recordset creating a <SELECT> tag.

How much faster would it be to move these functions to an activeX dll? Much faster?

Is there any IIS optimisations?

cheers,

Jim.

PS I've got 'till Oct 3rd. Needs to be FAST. Ulp.

 

[y2k1981]

add up the size of all of the files for the page(s) in question. this includes any image files, css files and js files and also the actual html/asp file. it shouldn't be more than 100MB as a general rule, if it is, that's probably why it's so slow.

 

[Streetdaddy]

large amounts of HTML can make the page take a long time to render. How many kilobytes of HTML are there on the page? Miles

Those Micros~1 guys sure know what they doing!