Bitcoin Forum
May 28, 2024, 12:15:50 PM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
   Home   Help Search Login Register More  
Poll
Question: Are you considerate of the web site owners forum SQL databse size ?
Yes - 2 (66.7%)
No - 1 (33.3%)
Total Voters: 3

Pages: [1]
  Print  
Author Topic: [POLL] Are you SQL Considerate ?  (Read 226 times)
Spoetnik (OP)
Legendary
*
Offline Offline

Activity: 1540
Merit: 1011


FUD Philanthropist™


View Profile
June 27, 2016, 08:48:33 AM
 #1

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 ?

FUD first & ask questions later™
HCLivess
Legendary
*
Offline Offline

Activity: 2114
Merit: 1090


=== NODE IS OK! ==


View Profile WWW
June 27, 2016, 10:36:25 AM
 #2

One of my websites runs so slow after it got hacked and I cleaned it up. IDK why.

Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!