2. ASPRunnerPro General questions
  3. Loading Page After Link to Database Times Out
This topic is locked

Loading Page After Link to Database Times Out

 		8/17/2006 10:16:43 PM
ASPRunnerPro General questions
W
 waynem author

I put up a large SQL table listing zip codes, cities, and states after testing with a small sample of that database. The lookups I defined would auto-fill state, zip, and area code based on the city.
After I put up the full database, the page has slowed to a crawl when I try to edit, and then errors out with this:
Response object error 'ASP 0251 : 80004005'
Response Buffer Limit Exceeded
/directories/wineries/dir_Wineries_edit.asp, line 0
Execution of the ASP page caused the Response Buffer to exceed its configured limit.
Any suggestions on how to handle this so the lookup fields can handle a large database?
J
 		Jane 8/18/2006

Hi,
This is a common Windows 2003 IIS problem.

Please read an article about it:

http://www.webcheatsheet.com/asp/asp_troubleshooting.php
W
 		waynem author 8/18/2006

Hi,

This is a common Windows 2003 IIS problem.

Please read an article about it:

http://www.webcheatsheet.com/asp/asp_troubleshooting.php


The problem isn't so much the error, but the cause of the error. I'm guessing the code is trying to pre-load the entire SQL database in order to populate the drop down menu. Is there any way to mitigate the impact of doing so with a large database, or as a best practice should I not use the drop downs?