...

View Full Version : should i use a database?



Bob42
02-08-2008, 05:03 AM
I've got a website that contains 500 or so pages. All of them are in the same format. I'm wondering if it would be best to place the content in each page in a mysql database and then display the info on a page by using the URL (page.php?id=001, id=002, etc).
The content in each page is basically lengthy summaries (1000 words or so) for TV shows, movies, etc. Right now I have each of those summaries on a separate page of its own. Should I stick to what I'm doing right now or use a database? I know that using a database would cut down the number of website pages of have, but is that the best way to go?

_Aerospace_Eng_
02-08-2008, 05:51 AM
Yes I would use a database. You would really only need one page format then use the id in the url to pull the appropriate information. The hardest part about the whole thing would be actually putting the data into the database.

dilipv
02-08-2008, 07:52 AM
hi Bob,

i saw your quote.i think there is currently you are not having the problems with the web site.if you want to reduce the Page of website you can go through the database.if you page think that your page will be increasing then could use database at that time.

Thank you
Dilip

CFMaBiSmAd
02-08-2008, 08:16 AM
Use a database. In addition to making the page format easier to change (there will only be one common page), it will make it easier to manage your site and to add new information.

I would hate to see what your folder/file naming scheme is now and how much work it is to add a page and to manage the menus.

By using a database, you can easily organize, search, and display content by categories, keywords, dates, ... and do things like search for and show related listings on one page.

Cymy
02-10-2008, 04:14 AM
I'm a big fan of databases, but only when they are needed. How often do you add new pages to your site? And is it causing you a big hassle? Search engines work better with databases than they used to, but a static page is still the most friendly toward search engines.

However, if you decide to change your site's format, having 500+ static pages would be a HUGE hassle (unless you use heavy CSS or are a super shell scripter).

I really like WebTeacher's WebDataPro (http://www.webteacher.com) but it's kind of expensive unless your site is actively making money--it's $599 per installation. I run it on four sites and have done so for over five years without any problems at all--it is very user-friendly. Check it out, it has a 30 day trial period.

I couldn't tell you about any other database options out there--when I look I never find anything that piques my interest that is under $1000, but you should look around--there may be a similar solution that is less expensive. If you find one, please follow up with details, I would be interested in a less expensive option.

Cymy

Bob42
02-10-2008, 07:11 AM
I'm a big fan of databases, but only when they are needed. How often do you add new pages to your site? And is it causing you a big hassle? Search engines work better with databases than they used to, but a static page is still the most friendly toward search engines.

I add pages once a week; no it's not a hassle because I'm basically just saving the same page over and over again, and then editing the info.


However, if you decide to change your site's format, having 500+ static pages would be a HUGE hassle (unless you use heavy CSS or are a super shell scripter).

Trust me, I know :) That's why I figured using a database would be the best way to go.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum