If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > advise - store or not to store in database

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 09-20-09, 08:02
geitvdplas geitvdplas is offline
Registered User
 
Join Date: May 2009
Posts: 8
advise - store or not to store in database

Hi!

Short introduction: So I'm making a sort of small/basic content managment system for my site. It's going to be a site where you can watch flash movies, comics and play games and everything is ofcourse made by me and my friend. With that beeing fancy and all; I'm not really experienced with php.

The final site will have some games and movies.. but not that much

Question: How much slower does my website get for visitors when using a database.
when is it a good choise to make a whole database for a website? When I've got like 20 movies/pages.. Can't I just make the CMS write a .php file precisely how I want it to be? With some includes() I could still make it slightly dynamic. Wouldn't that make the final website way faster for visitors?

I have no idea how slow/fast things are. So maybe someone can advise me or point me to a website that explains speed issues (or general explanation of when to databases). That would be much appreciated.

Have a nice day!
Reply With Quote
  #2 (permalink)  
Old 09-21-09, 00:59
mnirwan mnirwan is offline
Registered User
 
Join Date: Sep 2009
Posts: 64
Not sure what's your questions. It's too open ended. Many sites are 100% database backend and their speed are pretty fast. If your data doesn't change too often there are many ways of caching like generating static HTML pages off your database, or using some kind of database caching like Memcache .

Lastly, if you only care about managing the site (not programming or making the software backend for it), then you may be interested in PHPmotion.
Reply With Quote
  #3 (permalink)  
Old 09-21-09, 05:04
geitvdplas geitvdplas is offline
Registered User
 
Join Date: May 2009
Posts: 8
Thanks for your reply. One thing I'm going to look into is the static htmlpage generating, that sounds like just the thing I need.

I see now that my previous post was a bit cryptical. I was aiming for someone that could point me to a few methods. And maybe advise me wich one I should be using for my particular website.

I am having a hard time deciding wich way to go.
Reply With Quote
Reply

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 Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On