Remote SQL2000 with large asp ado dataset

I have a Server2003 running IIS6, 3GIG RAM, 2 processors. Have written sql
to execute within the asp page through odbc connection (no choice here).
From within sql query analyzer, takes about 42 seconds to run. But, when
rendering large recordset on asp page it takes about 9 minutes. Does this
mean that asp is holding the recordset until finished (about 9,000 records)
and then rendering? Is this what's happening? Is there a way to tweak the
asp to start rendering immediately or another way to speed up the response?

Thanks,
jb

Re: Remote SQL2000 with large asp ado dataset

The HTML alone, with no attributes, and assuming 4 columns, would result in
almost .5MB to be downloaded.

= 45 bytes * 9000 = 405,000
bytes. Now add in your average data per row, take that times 9000 and add it
to the 405,000 bytes.

You could turn buffering off, which may give the perception of being
speedier, but isn't really.

In any case, how could 9000 rows of data in a web page be useful to anyone?

Bob Lehmann

"janetb" wrote in message
news:2D5DE02D-19F9-4925-8066-019614B58396@microsoft.com...
> I have a Server2003 running IIS6, 3GIG RAM, 2 processors. Have written
sql
> to execute within the asp page through odbc connection (no choice here).
> From within sql query analyzer, takes about 42 seconds to run. But, when
> rendering large recordset on asp page it takes about 9 minutes. Does this
> mean that asp is holding the recordset until finished (about 9,000
records)
> and then rendering? Is this what's happening? Is there a way to tweak
the
> asp to start rendering immediately or another way to speed up the
response?
>
> Thanks,
> jb