If you have a site that receives ~50k searches a day to a little over 1 
million a month and all of your content is within SQL Server (and you don't 
have a search engine like Excalibur, etc...) what would be the best way to 
approach the fetch?  Open a connection - Store it within Application scope 
*or* Open and close a new connection each and every time a search needs to 
be made (or is there other great ways that can improve performance, etc.)?

Opinions?

Thanks in advance for any feedback,
Al

Platform: Windows 2000 Servers
Application SDK: .NET, IIS 5.0
Language: Visual C#
Database: SQL2k using Full-Text Catalog (search's would being done through a 
proc)



_________________________________________________________________
Join the world?s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com