Reputation: 21
Can anyone tell me if this is possible and if so point me in the right direction on how to implement it!
Basically I have a panel on my website that's hitting the database and outputting the data to the screen, everytime somebody hits the page. This is a heavy burden on the server and what I would like to do is create a HTML file with the information every 30 minutes and then request this HTML file with an include on the website.
<!--#include file="myHTMLpanel.asp"-->
By the way, i'm using classic .ASP ;o(
Upvotes: 1
Views: 285
Reputation: 168705
You might want to investigate a pre-built caching solution on the server rather than writing it manually.
A product such as Varnish will make it virtually effortless.
Upvotes: 0
Reputation: 10397
ASP provides a great mechanism for generating web pages, no point in creating your own. Use caching, like this. Create a scheduled task that hits the server every 30 minutes and breaks the cache.
Upvotes: 1
Reputation: 5376
Use VBScript to write a script that will run your query and write out the HTML page. Schedule it to run every 30 mins via scheduled task.
Upvotes: 0