Lost Password?

Go Back   CodeCall Programming Forum > Web Development Forum > Database & Database Programming

Database & Database Programming MySQL, Oracle, SQL, PL/SQL, ABAP, Smart Forms, and other databases and languages. A database is an organized body of related information used in many websites (including CC).

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-12-2007, 02:12 PM
neo1erk's Avatar   
neo1erk neo1erk is offline
Newbie
 
Join Date: Dec 2007
Posts: 11
Rep Power: 0
neo1erk is on a distinguished road
Default Storing webpages in a database

I want to make a website manager, however i am wondering how efficient it is to store files in a database. While i am trying to hardcode text where possible, should i be going out of my way to hardcode pages, or does it not matter that much, when compared to the ease of storing them in a database.
So my question is: are there any disadvantages from storing a lot of stuff in the database? i know forum sites store all their content there, so i don't think it would a problem.
Any thoughts would be appreciated.
Thanks
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

Sponsored Links
  #2 (permalink)  
Old 12-13-2007, 10:40 AM
WingedPanther's Avatar   
WingedPanther WingedPanther is offline
Super Moderator
 
Join Date: Jul 2006
Age: 35
Posts: 2,035
Last Blog:
NaNoWriMo Day 23 The...
Rep Power: 24
WingedPanther is a jewel in the roughWingedPanther is a jewel in the roughWingedPanther is a jewel in the roughWingedPanther is a jewel in the rough
Default

The biggest disadvantage I can see is trying to alter the pages. On the other hand, if you have a huge site where you want to index the pages by search parameters, you can store the page with the parameters as additional fields in the record.

Are you doing any server-side scripting? That may help reduce the number of pages you need to deal with.
__________________
CodeCall Blog | CodeCall Wiki | Shareware | Linux Forum
Chat with other CodeCall members on IRC; connect to irc.codecall.net and join #codecall
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 12-13-2007, 12:04 PM
neo1erk's Avatar   
neo1erk neo1erk is offline
Newbie
 
Join Date: Dec 2007
Posts: 11
Rep Power: 0
neo1erk is on a distinguished road
Default

I am doing the project in php. I think will store them in the database, since i want to be able to make mods and addons, and having a database would make it easier to get the data into php.

Thanks for your thoughts. Only thing i am trying to find is ways to cache common database queries in mysql. I was hoping just to be able to put menu's into the database just for ease of editing.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Doubt on database connection!! sania21 Visual Basic Programming 3 12-04-2007 11:14 PM
Retrieving Access Database tigger Visual Basic Programming 0 07-06-2007 12:27 AM
Best program for SQL database manipulation Rhadamanthys Database & Database Programming 3 07-02-2007 02:32 PM
Best way to save lots of small values (in a database)? Vantage General Programming 2 05-14-2007 07:57 AM
Database and Database Users DevilsCharm Database & Database Programming 2 08-27-2006 10:22 AM


All times are GMT -5. The time now is 08:12 AM.

Contest Stats

John ........ 223.00000
dargueta ........ 168.00000
Xav ........ 164.00000
gaylo565 ........ 18.00000
WingedPanther ........ 15.00000
|pH| ........ 15.00000
Johnnyboy ........ 3.00000
navghost ........ 1.00000

Contest Rules

CodeCall Goal

Goal: 100,000 Posts
Complete: 66%

Ads