Hi Guys,

I have a problem and I'm wondering if anyone here is able to help me out. 
I'm developing an intranet application with ASP and SQL 2000. To retrieve 
records from the database I use stored procs in the SQL DB This all 
together is no probleem. But when I want to display the results It takes 
so much time that in some cases there is a scripttimeout. Of course I can 
set the timeout property higher, but I don't think it'll solve the 
problem. I'm talking 1000 till 20.000 records which have to be shown. I 
build in some checkpoint where I measure the performance. What I found out 
is, that it takes about 2 seconds to retreive the recordset. But after 
that I have to iterate through the recordset and add some html to show the 
records. To retrieve the results form the database for about 5000 records 
is maybe takes 1 second if I use the query analyser. In the asp pages it 
takes at least 20 seconds before the result is shown. All I could find out 
is that the whole page is already in memory, but when it's parsed to the 
client there's a dramatic loss of performance. Does anyone have 
suggestions to speed this up.

Thx.

Stephan