What would be the best method of information retrieval?

Discussion in 'PHP' started by SoftCloud, Feb 4, 2008.

  1. #1
    I have two decisions... I am currently making my own Wiki-based site, however because I don't wish to use MediaWiki (what WikiPedia uses) or any other software like that, I am making my own... however I want to know as this will soon start having thousands of articles on it which one of the following options would be better for retrieving the information?? (To save on server load)

    1) MySQL Database

    or

    2) Text Files (using fopen(), etc..)

    ??
     
    SoftCloud, Feb 4, 2008 IP
  2. ToddMicheau

    ToddMicheau Active Member

    Messages:
    183
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    58
    #2
    You definitely want to go with sql if you having thousands of articles. I mean how would you incorporate a search function with files? Open them one by one and search for the text? That would take a nice long time, and substantially add to the server load. That and you'll want to have user data so they can login and create their own articles, right?

    Just my opinion but I think sql would be best.
     
    ToddMicheau, Feb 4, 2008 IP
  3. Possibility

    Possibility Peon

    Messages:
    350
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    0
    #3
    SQL hands down. Doing that with that many text files will become incredibly slow and resource intensive. And like Todd said, implementing features like searching would become so much more complicated.

    If you're worried about taking the time to learn SQL, don't be. PHP interacts really well with MySQL, and it doesn't take much to learn at all.
     
    Possibility, Feb 4, 2008 IP
  4. SoftCloud

    SoftCloud Well-Known Member

    Messages:
    1,060
    Likes Received:
    28
    Best Answers:
    2
    Trophy Points:
    120
    #4
    Cheers guys ... also don't worry I know MySQL (been using it since I was 13) :D
     
    SoftCloud, Feb 8, 2008 IP
  5. gwkg

    gwkg Peon

    Messages:
    143
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #5
    text files are not an option for the type of site you are creating.
     
    gwkg, Feb 8, 2008 IP
  6. dwayne12

    dwayne12 Well-Known Member

    Messages:
    184
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    110
    #6
    Definitely SQL mate. If you use text files you'll have loading issues. It's much easier to query a database, pull the content and render it.
     
    dwayne12, Feb 10, 2008 IP
  7. jasondavis

    jasondavis Peon

    Messages:
    41
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    mysql/php work great together
     
    jasondavis, Feb 10, 2008 IP