Are there any drawbacks in storing some SQL queries in application variables to eliminate some SQL connections? We currently have a very busy SQL server and need to cut back on the number of connections. Is there such a thing as too many application variables? Right now we have our product brand names in application variables. Now I am considering caching the individual product model names in application variables as well. This will be more efficient than querying the database for this information every time the page is accessed, right?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Application Variables
- Thread starter Jeremy21b
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question