Use of global.asa
Posted on 2013-01-03
Can anyone remind me the use of global.asa?
For example, I currenly have a shopping cart that I wrote my self, all of the prices are hardcoded in one common.asp file that I include where I need it.
Now, I need to store the prices into a db, so management can change them, and within my common.asp I'd get my prices from the db. However, I don't want to open my db every time I include common.asp and waste resources, as I'll be looping through 45 recs every time.
With this said, would this be where global.asa comes in? I was thinking of having under Session_OnStart
arePricesRetreived = False
Then in common.asp, do:
If arePricesRetreived = False
'Retrieve from DB
arePricesRetreived = True
Would this be the propper logic and use of global.asa?