Thanks you very much for all your suggestions. I really appreciate it. Grant Cooper
----- Original Message ----- From: "Matthew Baranowski" <[EMAIL PROTECTED]> To: "Grant Cooper" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, November 27, 2002 9:23 AM Subject: Re: Data base driven web page idea - need help! > Hi Grant: > > The answer to your question depends on a lot of details. In most cases, the > solution you have chosen is just fine. The real question you need to answer > is, "Does your solution meet your needs?" If you can answer yes to this > question, your solution is fine. > > Your solution gives you a couple of advantages: > 1. As you said, fewer hits against the database. > 2. Faster downloads for your user. Static HTML pages download faster than a > dynamic alternative. > 3. Static pages will get crawled and added to search engines; sometimes > dynamic pages won't. > > Some disadvantages: > 1. You have a delayed update to your Web page. If a faculty member notices a > critical error on a Web page, they must contact you or otherwise figure out > how to trigger an update. > 2. There are things you can do with a dynamic page that you cannot do with a > static page. > > > Here's my QUESTION! Because some of the program information is large I > don't > > want to query the data base everytime do I? > > Like I said, your solution will probably work just fine, but it is probably > unnecessary. You say the program information is large, but it would have to > really REALLY large for it to make much difference. With a college of 1600 > students, it does not sound like your Web site is going to have much > traffic. Php and MySQL are pretty efficient. > > My advice is to test your assumptions; does retrieving the large Web pages > from the database make much difference? > > Good luck, > > Matt > > Matthew P Baranowski > Data Manager, Office of Educational Assessment > University of Washington > > > ----- Original Message ----- > From: Grant Cooper <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, November 26, 2002 10:38 PM > Subject: Data base driven web page idea - need help! > > > > I need help. I am building a database for a small college that wants to be > > able to update their program information for each department through an > > web/gui program. > > > > I've decided to use, MYSQL, Apache, PHP and FreeBSD as the OS. (I built my > > web page this way) > > > > Here's my QUESTION! Because some of the program information is large I > don't > > want to query the data base everytime do I? > > > > This would take up to many resources. So I've decided to write a program > > that will take the information from the MYSQL tables and build static > pages > > every night and remove the old ones through a cron job? > > > > How does this sound? > > > > Is this standard practice, if not what would be a better way of doing > this. > > This college has about 1600 students? > > > > Thanks in advance, I plan on doing alot of planning and really apreciate > > reading this email. > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php