7 replies
by ukothari
It is clear that you are mostly having problem with large amount of data that query moght be returning. Amount of time it takes depends on what you are querying rather than whether it has primary key or not. Please give query you are trying and I can help you. I don't think you can set the Session timeout for single page however you can set the timeout value during Session_onStart event in global.asa
Hope it helps.
Uday
by dparkins
by andrew
You can increase the ASP timeout like this:
Server.ScriptTimeout=600
this increases it to 10 mins (default is 90 secs).
by dparkins
by ranarc
even with a script time out, with almost 3 mil records, your end user is going to complain about response times.
Couple of things you could try ... the easiest is to create a stored procedure for your query ... this is faster than having the sql inyour asp page. The second method requires a lot more work ... create html files for each record with meta tags, index the html files using get Index Server and query Index server .. that will give you real quick results ... cheers, have fun!
by dparkins
by dparkins
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending