[thelist] BIIIIIG tables - HTML or ASP Limitation?

[Scott Dexter]

> -----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?

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