Flat File Storage v...
 
Notifications
Clear all

Flat File Storage vs MySQL Storage

4 Posts
4 Users
0 Reactions
1,424 Views
(@guest2010)
Posts: 0
 

Is there any particular benefit to saving the stories in files rather than MySQL database or the other way around?


 
Posted : 14/08/2007 1:40 am
 Elle
(@jenny)
Posts: 594
Honorable Member
 

I'd rather save through MySQL, because I'd have to CHMOD /stories. πŸ˜›

(Unless you're on a server where CHMODing is optional. I was on one where you didn't need to CHMOD to write to the server.)


archive: dramione.org
site: accio.nu

Available for skin/mod commission! πŸ™‚

 
Posted : 15/08/2007 3:29 pm
Jan_AQ
(@jan_aq)
Posts: 1300
Noble Member
 

I think MYSQL may have higher limits for word count in chapters.


Whoever said nothing is impossible never tried slamming a revolving door.

url: https://www.potionsandsnitches.org/fanfiction
php: 7.4.33 msql: 5.6.51-community GPL
efic version: 3.5.5 latest patches: yes
bridges: none mods: challenges, tracker, story end, beta, word

 
Posted : 15/08/2007 11:54 pm
(@tammy)
Posts: 2577
Member Moderator
 

File storage:

Pro: There's no word limit per chapter.
Con: You must have the stories/ folder CHMOD'd to 755 or 777.  Depending on the security of the server this could leave you open to hacking attacks.

mySQL:

Pro: You don't have to worry about folder permissions, safe_mode or any of that.
Con: big databases can run slower.  You're getting a lot more data from the database. This can cause problems on some hosts.

It's a toss up.


 
Posted : 16/08/2007 12:09 am
Share: