Would you store words in SQL database or on file?

[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?

[sarettah]

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.

.

[lakerslive]

building a dating site

[sarettah]

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.

.

[sarettah]

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.

.

[Klen]

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.

[CurrentlySober]

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....