Would you store words in SQL database or on file?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • lakerslive
    Confirmed User
    • Aug 2012
    • 929

    #1

    Would you store words in SQL database or on file?

    which is better? seo + site performance?

    For example the word "HELLO" is it more efficient to store that in an sql database and call it or just leave it in the .php file itself?
  • sarettah
    see you later, I'm gone
    • Oct 2002
    • 14297

    #2
    Originally posted by lakerslive
    which is better? seo + site performance?

    For example the word "HELLO" is it more efficient to store that in an sql database and call it or just leave it in the .php file itself?
    Depends on how many words you are storing and the logic required in using them.

    If you can hardcode the word into the program as a literal then that is quickest. If it is a short list of words then using an array in the php program could be a good way to go depending on what you want to do with them.

    So, if you can say what it is you are trying to do with the words, it would help.

    .
    Last edited by sarettah; 04-21-2013, 08:14 PM.
    All cookies cleared!

    Comment

    • lakerslive
      Confirmed User
      • Aug 2012
      • 929

      #3
      building a dating site

      Comment

      • sarettah
        see you later, I'm gone
        • Oct 2002
        • 14297

        #4
        Originally posted by lakerslive
        building a dating site
        That answer is probably 100% correct but is totally useless. ;p

        How are you trying to use this list of words?

        If you can give a description/example of what you are trying to do with it, it would help. If you feel that gives too much of a secret away then hit me up in icq and we can yak about it there.

        .
        All cookies cleared!

        Comment

        • sarettah
          see you later, I'm gone
          • Oct 2002
          • 14297

          #5
          Originally posted by lakerslive
          which is better? seo + site performance?

          For example the word "HELLO" is it more efficient to store that in an sql database and call it or just leave it in the .php file itself?
          I might have misunderstood what you were asking. Are you asking about the best way to store your html info (header, footer, etc) ?

          I had taken what you were asking as being a list of words that you are using in some dynamic fashion such as using Mr. when you encounter a male gender versus using Ms. when you encounter a female gender.

          I had a whole big post written up about the storing of the html page components but I read through it and it contains a lot of very newb type info in it so I didn't want to post it.

          .
          Last edited by sarettah; 04-21-2013, 09:52 PM.
          All cookies cleared!

          Comment

          • Klen
            • Aug 2006
            • 32235

            #6
            For seo perfomance,it's completely irrevelant how do you store it as output is always same.For speed performance,it depend what kind of data is-if it's fixed,a constant then it's better to store into file,if it changes a lot,then into database.

            Comment

            • CurrentlySober
              Too lazy to wipe my ass
              • Aug 2002
              • 38944

              #7
              i store mine in moms closet, upstairs... (in the REAL house bit)

              Considering hardly anyone is allowed up there (Not Even Me...) Its prob pretty safe....


              👁️ 👍️ 💩

              Comment

              Working...