Jump to content

Queries


fernyb

Recommended Posts

Okay so I am building a web application some sort of web blogging type of software.

Well it basic function is to enter a new entry into the database and then it will display it on the front page of the site.

 

Now I need some advice would it be better and faster to have it input the data into the databse and at the same time create a html file that will be called into the main page instead of always making query calls to the database.

 

So everytime the user add a new entry a new row is added with the content and a new page with that content aswell. and when they modify it or delete it the html file wll do the same be delete or modified with the same contents that are inputed into the database?

 

in other words is it good idea to always make query calls to the database when the user access the page?

Link to comment
Share on other sites

It'd be far easier on the server to do it the way you suggest. Once the new entry has been added to the database, initiate another script that basically generates a static HTML page from whatever queries you would normally run to display the entries to the user. There even exists a tutorial on this site for the same purpose. If you feel like searching, it's there, but you seem to have a grasp of the concept--go for it.

 

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.