Queries

[fernyb]

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?

[Arenium]

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.