slow loading asp pages

<i><b>Originally posted by : John Stewart (tstewart@adept.net)</b></i><br /><br />I have a database set up at www.antiqueshopsusa.com/shopguide.asp . When you search for a city and state abbreviation, all works fine but it load really slooooow. Any suggestions? I need it to load faster or people will lose interest.<br /><br />Thanks,<br />John

<i><b>Originally posted by : steve</b></i><br />Use response.buffer=True. Use stored procedures to return data to the asp page. Here is a link for asp tips and tricks.<br /><br />http://msdn.microsoft.com/workshop/server/asp/asptips.asp<br /><br />------------<br />John Stewart at 5/11/2000 6:49:53 PM<br /><br /><br />I have a database set up at www.antiqueshopsusa.com/shopguide.asp . When you search for a city and state abbreviation, all works fine but it load really slooooow. Any suggestions? I need it to load faster or people will lose interest.<br /><br />Thanks,<br />John