Any disadvantages to using application variables?

[gagslondon]

A collegue and myself are creating a medium sized SQL Server 7 database. we are wanting to use application variables to store data for objects such as drop down boxes and some of the databases tables. For example if we store Country Name and CountryId in an application variable that is array we would not have to query the db to get the country name. Are there any disadvantages to this teqnique?

 

[silvers5]

Will use server resources! (memory) but on other hand if your site is highly visited it will be an optimum since the application variable have a general scope.. Silvers5
As seen on EE