APP Slow on IIS 6.0, not on IIS 5.1

Hello

I written a application which pulls 800 rows of data from a sql2000 (SP3)
database on a APSX form. I have some filters in the heading of the ASPX page,
some calcalations are made with the data. I use the databind en repeater commands
for getting the data out.

All this works fine on my local machine, even if I use a other PC on the network to
access the IIS 5.1. This is where I put the ASPX form. The form is very fast on load,
regardless if I call it remote or local. The SQL database also resides on my local machine.

Now I've put the form on the W2003 (IIS 6.0) webserver, the data on another server
which is our dedicated SQL server. Now the ASPX form takes minutes to load. Sometimes
1 minute sometimes 10. When I run the form local on the W2003 machine it's fast.

I've ruled out the my local machine by turning it off, in case somewhere in the script it called
my local IIS or SQL.

All other application on the webserver and SQL server run fast and without any problem's.

When I don't bind the data on the form, it run's fine and fast.

When I bind 100 rows to the form it runs better, performance is somewhat slow (10 secs to load).

Does anybody know if this is a bug? or maybe has some idea on how to resolve it?

Arno.

It could be any number of things.
Network traffic.
Database connectivity.
Database structure, indexes, etc...
Calculations that are being done on the page.

Try not doing any of the calculations and see if that returns the database faster. This way you will be able to tell if the latency is pulling the data from the database or if it is the calculations being done on the page.