Jump to content

Converting Database info into static pages that update every so often.


Mateobus

Recommended Posts

I have a website that record various team records and conference standings, that I don't wan't to have to recompute every time someone requests a page. I also don't want to have columns in my table for wins losses etc, becuase if a game gets edited all of those columns will need to as well.  The best solution would be to have static pages that are computed every so often.  Does anyone know how to do this?  Thanks.
Link to comment
Share on other sites

well one way could be to make a php admin opage where you choose to calculate/update and then it deletes or archives the current file and then writes a new html file based on the data u give it. therefore you can output to .htm files and not have any querys run at all and update at your wish..

another way could be to run a query everytime a user accesses the page to check the creation date of the file and update when it is out of date..

Regards
Liam
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.