I have an sql2000 table with 2.8million records in it. Along with that I have set up an asp page to retrieve data from this table and show it on the screen. The problem is this; the page times out every time. Is there some line of code I can put on my asp page to lengthen the time? I don’t want to do it in the global asa file. Or, is there something I should be doing with the table itself. I’ve set it up with a primary key and indexed it. Thanks in Advance. Dave
