[thelist] BIIIIIG tables - HTML or ASP Limitation?

Scott Dexter sgd at ti3.com
Wed Apr 4 15:40:08 CDT 2001

> -----Original Message-----
> From: Luther, Ron [mailto:Ron.Luther at COMPAQ.com]
> I think this is a "common" problem.  You run an ASP report. 
> It tries to
> bring back a 35,000 record recordset ... and it simply "times 
> out" in the
> user's browser.

what's your script timeout set to?

set it explicitly at the top of the page that will take a while, like so:
Server.ScriptTimeout = 3600 ' in seconds

also, what's the code that reads the recordset and spits html? Remember the
response.write thread a while back (who could forget)? --35,000 Rows will
definitely highlight inefficiencies....

> The difference is important to me because, if I'm guessing 
> rightly, I should
> be able to work some "mime-type" magic, write the ASP 
> recordset to a file as
> ... say .... Excel or CSV ... and then link to the file and 
> have things all
> work nicely together.  [All in-house intranet where all my 

I've done this, and you don't need mime magic. Followup for code =)

> Am I close to the mark? ... or do I need to pick up a case of 
> Tabasco sauce
> to wash down all the crow I'm gonna have to eat?

also make sure the db isn't timing out sending the data....

you like Tobasco, yes?

work: http://www.ti3.com/
non: http://thinksafely.org/

More information about the thelist mailing list