T
Tapplication
I do not consider myself a ASP expert by any means so I must ask this
question to see if this is normal or if there is a better way.
I have a web site that I have developed that uses a lot of DB lookups
for Comboboxes and sections, as well as other configs- All in a
database.
Instead of having this done on EVERY page via direct DB lookups.... We
are talking lots of SQL lookups for every page.
What I want to do is have an included page say SiteHeader.ASPX and do
the following
If Not Application("Initialized") then
InitializeMyApplication()
InitializeMyApplication() Will Do all the database Lookups and create
dropdowns dyanmicly and assign it to a string -- say S,
Application("SiteDropDownList5") = S
Application("Initialized") = True
Then just used this dynamically generated HTML on my pages.
Please Select: <%=Application("SiteDropDownList4")%>
Is this normal?
question to see if this is normal or if there is a better way.
I have a web site that I have developed that uses a lot of DB lookups
for Comboboxes and sections, as well as other configs- All in a
database.
Instead of having this done on EVERY page via direct DB lookups.... We
are talking lots of SQL lookups for every page.
What I want to do is have an included page say SiteHeader.ASPX and do
the following
If Not Application("Initialized") then
InitializeMyApplication()
InitializeMyApplication() Will Do all the database Lookups and create
dropdowns dyanmicly and assign it to a string -- say S,
Application("SiteDropDownList5") = S
Application("Initialized") = True
Then just used this dynamically generated HTML on my pages.
Please Select: <%=Application("SiteDropDownList4")%>
Is this normal?