Topic: [POLL] Are you SQL Considerate ? (Read 226 times)
One of my websites runs so slow after it got hacked and I cleaned it up. IDK why.
As the Poll states.. please vote !
What do i mean ?
Simple if you have a forum it probably has an SQL database storing the content of the forum.
The forum probably is written in PHP then when it gets loaded it fetches the SQL database file.
..loads it into memory and puts it all together to show you the final web page.
So since it is a FILE it can get rather large.
Loading a file that gets larger every year is going to require more resources.
Meaning your spammy garbage shit posting & stupid pointless comments
..means theymos has to go out and buy another computer !
Do you give a shit ?
Seriously i want to know people.
I do and always have.
I have tried to be respectful of this forum and any other i have went to (or started)
How ? ..should be pretty obvious.
- Do NOT create shitloads of new accounts !
- Keep post counts low.
- Don't make too many topics.
- Don't make comments too long (with out a good reason)
- Don't overload the servers by refreshing pages too much (services or manually etc)
There is always things you can do to be conservative.
I just now edited a comment of mine to remove a blank line for example.
Chances are that just removed 2 chars from the DB or 1 space etc ..but still.
It's been years since i have looked inside an SQL database so i forget what the full syntax was like.
Anyway.. are you SQL-Considerate ?
What do i mean ?
Simple if you have a forum it probably has an SQL database storing the content of the forum.
The forum probably is written in PHP then when it gets loaded it fetches the SQL database file.
..loads it into memory and puts it all together to show you the final web page.
So since it is a FILE it can get rather large.
Loading a file that gets larger every year is going to require more resources.
Meaning your spammy garbage shit posting & stupid pointless comments
..means theymos has to go out and buy another computer !
Do you give a shit ?
Seriously i want to know people.
I do and always have.
I have tried to be respectful of this forum and any other i have went to (or started)
How ? ..should be pretty obvious.
- Do NOT create shitloads of new accounts !
- Keep post counts low.
- Don't make too many topics.
- Don't make comments too long (with out a good reason)
- Don't overload the servers by refreshing pages too much (services or manually etc)
There is always things you can do to be conservative.
I just now edited a comment of mine to remove a blank line for example.
Chances are that just removed 2 chars from the DB or 1 space etc ..but still.
It's been years since i have looked inside an SQL database so i forget what the full syntax was like.
Anyway.. are you SQL-Considerate ?
Jump to: