processing time

[nivini]

Hi all
Im ecountering a cardinal problem.
I have this asp file which process data from the db,
When the db table contain only 60 records it works fine,
in matters of time and precision, When the table contains 6000 records, it seems as if the asp processes only a small part of table, The asp file shows all design (css & html) but not the asp code outcome.
What am i missing?
many thanks in advance
nivini

 

[guitardave78]

You could be encountering a script time out.
Couple of things you want to do to check and to help
first after the initial <%@LANGUAGE="VBSCRIPT"%> at the top of the page add
<%response.buffer = true%>

after each itteration of the loop add response.flush()

If you then view it in firefox the asp result will be printed as it goes along and you can see how much gets processed.

The other thing to do is increase the script time out.
under the <%response.buffer = true%> add
<%server.ScriptTimeout=30*60%> this sets teh script time out to 30 minutes.


}...the bane of my life!

http://www.fuzzyd.co.uk

 

[nivini]

Thanks guitarDave for your reply