ASP/Access DB

[Kashi McGilloway]

I have a small company creating a small site. Until it
gets big, they
switch to an MSSQL database hosted on a full-t1 site, and
all that jazz
they've got lowly ol' me working it into an Access
database.

I'm logging all the code with a logging function I
created. The log
function writes a row to the database each time I call the
function with
something like, "User logged into the web site".

I came to the stark realization that each time a user
loads my page they hit
the database with an SQL query at least 40 times. That
seems like a lot.
It seems unecessary given the simplicity of the site.

I realized a lot of my data is static. So I thought, "why
do i need to hit
the database and pull this data constantly if it will
rarely change?"

What methods are people using to mitigate database hits?
Can a simple array
be stored into a global ASP variable that all the sessions
could access?
XML (but I don't really know it well yet)?

I'm looking for advice, thanks!

 

[Dave]

I'm developing a site in a similar manner. I plan on using the Server's Task
Scheduler to initiate an Access database at midnight. Once open, Access will
run a macro to recreate a .htm file. The Task Scheduler will also close the
program after it has run for 5 minutes which is more than enough time to
create the updated .htm file.
Perhaps this idea will suite your needs too.

Dave