Jump to content


Photo

Queries


  • Please log in to reply
1 reply to this topic

#1 fernyb

fernyb
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 10 December 2005 - 09:06 PM

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?

#2 Arenium

Arenium
  • Staff Alumni
  • Advanced Member
  • 111 posts
  • LocationMassachusetts

Posted 11 December 2005 - 02:47 AM

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.





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users