DZComposer Posted September 22, 2010 Share Posted September 22, 2010 Please do not start any more threads whose purpose is solely to count a large number.Let's remember how this works: When you submit a post, the forum software creates records in 2 or 3 database tables to track who posted it, the post status, the post's content, IP address posted from, if the post needs moderation via the report system, etc. There are probably at least 50 bytes of information stored in addition to the post's text. This number: 1,265,564 is 7 characters. Large number? Yes. Filesize? 7 bytes (9 if you include the commas). Notice all the overhead that goes into storing those 7 bytes? Now multiply that by however many number of posts your trying to get. It's a huge waste of database space that is not worth what the thread is trying to accomplish.Disk space isn't the only issue. The larger a MyISAM table is, the longer it takes to search records. So, this slows down the search function, as well as several back-end functions that deal with posts. Link to comment Share on other sites More sharing options...
Guest Mr. Mario Posted September 22, 2010 Share Posted September 22, 2010 Does this count also for other threads like What have you noticed about the user above (game)? Link to comment Share on other sites More sharing options...
Guest FoXXX Posted September 22, 2010 Share Posted September 22, 2010 :slippy: Understood! Link to comment Share on other sites More sharing options...
DZComposer Posted September 22, 2010 Author Share Posted September 22, 2010 Does this count also for other threads like What have you noticed about the user above (game)?No. That isn't posting for the sake of posting, there is actual content in a thread like that.I'm more talking about threads like the "Countdown from 1000000" thread.Yes, more posts mean the database has to work harder, but if the posts are worth keeping it is an acceptable performance hit. Link to comment Share on other sites More sharing options...
Kid_Cortet Posted September 22, 2010 Share Posted September 22, 2010 yes sir, understood. Link to comment Share on other sites More sharing options...
The Shaper Posted September 22, 2010 Share Posted September 22, 2010 No worries, there will not be a topic made like that again. It was fun while it lasted I guess. Link to comment Share on other sites More sharing options...
Guest Mr. Mario Posted September 22, 2010 Share Posted September 22, 2010 No. That isn't posting for the sake of posting, there is actual content in a thread like that.I'm more talking about threads like the "Countdown from 1000000" thread.Yes, more posts mean the database has to work harder, but if the posts are worth keeping it is an acceptable performance hit.Okie-dokie. Link to comment Share on other sites More sharing options...
Guest Julius Quasar Posted September 22, 2010 Share Posted September 22, 2010 Sorry about that. :oops: Link to comment Share on other sites More sharing options...
Falconman Posted September 24, 2010 Share Posted September 24, 2010 hmmm.....no clue wat all this bytes are but oh well.......k (even though most of us never started one) Link to comment Share on other sites More sharing options...
Dublinthefox Posted September 24, 2010 Share Posted September 24, 2010 Understood DZ. Link to comment Share on other sites More sharing options...
Arashikage Posted September 27, 2010 Share Posted September 27, 2010 hmmm.....no clue wat all this bytes are but oh well.......k (even though most of us never started one)If you're saying what I think you're saying and you don't know what a byte is, allow me to explain. A byte is a unit of measurement for digital memory. One byte is approximately one thousandth of a kilobyte, and one kilobyte is approximately one thousandth of a megabyte, the megabyte is approximately one thousandth of a gigabyte and the gigabyte is approximately one thousandth of a terabyte. Hope I could shed some light on this. Link to comment Share on other sites More sharing options...
DZComposer Posted September 30, 2010 Author Share Posted September 30, 2010 hmmm.....no clue wat all this bytes are but oh well.......k (even though most of us never started one)A byte is a unit of data storage. It isn't the smallest, that's the bit, but bytes are the main unit of data storage. A single ASCII character (like the ones in this text*) is 1 byte.While bytes are given metric unit names, they ARE NOT METRIC! Though some manufacturers of storage devices market metric because the math is easier (this has led to a lawsuit, because 1000 kB IS NOT 1 MB)In metric, there are 1000 units in a kilounit. But, bytes are different due to being in base2. A kilobyte is 1024 bytes. A megabyte is 1024 kilobytes (1,048,576 bytes), a gigabyte is 1024 megabytes (1,073,741,824 bytes), and a terabyte is 1024 gigabytes (1,099,511,627,776 bytes).Now that you know that, I bring up a point of confusion that a lot of people get wrong. This unit: Mbps (sometimes written Mb/s). This is a compound unit. The s is seconds. So, let's focus on the Mb. Mb IS NOT THE SAME as MB! MB is megabyte. Mb is megabit. Every once in a while, I hear someone pronounce mbps as "mips." This is incorrect, as MIPS is a separate unit (millions of instructions per second) used to measure one aspect of microprocessor efficiency.Data transfer is measured in bits per second. Bits are also counted binary, not metrically. (1 kb = 1024b, etc) So, if your internet connection is 12 Mbps, that is NOT 12 Megabytes per second, but rather 1.5 Megabytes per second. Why? There are 8 bits per byte. So, to get the throughput in bytes, you need to divide by 8. A gigabit would be 128 Megabytes (1024 Megabits/8 = 128 megabytes).There is also the nyble, which is 4 bits (half of a byte), but that is only really used in programming. In hex, a byte is 2 digits. So, this is 4 bytes: Monospaced Text 2E A7 8F 2D It is also 8 nybles.----*That was a bit of a lie, because the database isn't ASCII, it is UTF-8 to allow for non-latin characters to be used on the boards. Non-special characters are still 1 byte, but UTF-8 characters can be as large as four. Link to comment Share on other sites More sharing options...
sjrathbun812 Posted November 5, 2010 Share Posted November 5, 2010 oops, sry. I think I did this. XD Don't worry! I won't do it again. Link to comment Share on other sites More sharing options...
Matrilwood Posted November 14, 2010 Share Posted November 14, 2010 Woah numbers!Anyway, if HDSpace is causing you to slow down, maybe you should get another HD (If you have less than 15% HDSpace then your computer slows down). You can get Terabyte HDs at a reasonable price now-days. I've seen one for about $100. Which will last you the next couple of years (Unless you do something stupid like create a matrix-server or something) I don't think secondary hard drives need to remain 15% free, but for best performance try to keep the primary one (C:) as clear as possible (Say 80% full). Link to comment Share on other sites More sharing options...
TheRedFox8 Posted November 14, 2010 Share Posted November 14, 2010 Why not just delete useless threads that are causing that issue so it will free up space rather than archiving it?I can understand the difference between a thread worth archiving, and a thread that should just get deleted. Link to comment Share on other sites More sharing options...
sjrathbun812 Posted November 14, 2010 Share Posted November 14, 2010 ^He's got a point. Link to comment Share on other sites More sharing options...
TheRedFox8 Posted November 15, 2010 Share Posted November 15, 2010 Yay! Someone agrees! Link to comment Share on other sites More sharing options...
Matrilwood Posted November 25, 2010 Share Posted November 25, 2010 What about last poster wins? Shouldn't that fit under the same category? Link to comment Share on other sites More sharing options...
Guest Mr. Mario Posted November 25, 2010 Share Posted November 25, 2010 What about last poster wins? Shouldn't that fit under the same category?Yeah...I was wondering about that.... Link to comment Share on other sites More sharing options...
Guest DRL Posted November 25, 2010 Share Posted November 25, 2010 What about last poster wins? Shouldn't that fit under the same category?Not if peoples were following the main rule,"Do post after two other posts have been made."Furthermore, it may now get locked, not because of it's content,but because it is now an RP outside the RP section. And was notaproved. (Not that I like to wet the party... Just following the rules). Link to comment Share on other sites More sharing options...
Guest Mr. Mario Posted November 25, 2010 Share Posted November 25, 2010 Not if peoples were following the main rule,"Do post after two other posts have been made."I don't see that happening anytime soon...Furthermore, it may now get locked, not because of it's content,but because it is now an RP outside the RP section. And was notaproved. (Not that I like to wet the party... Just following the rules).Well I agree, though it sounds like a topic, it's now becoming a RP.BTW DZComposer, you should maybe at least modify your frist post to include topics like Last Poster Wins (If it qualifies). Link to comment Share on other sites More sharing options...
Matrilwood Posted November 25, 2010 Share Posted November 25, 2010 It is now an RP outside the RP section. And was notaproved.That's most likely because the rules in the RP section are far to strict, if they loosened the noose then people might actually like using the RP section. But that's going on a tangent. Link to comment Share on other sites More sharing options...
Guest Mr. Mario Posted November 25, 2010 Share Posted November 25, 2010 That's most likely because the rules in the RP section are far to strict, if they loosened the noose then people might actually like using the RP section.Agreed. I also think the RP board isn't that active as it used to be...possibly because of the rules... Link to comment Share on other sites More sharing options...
Deploy Posted April 6, 2011 Share Posted April 6, 2011 My new thread is NOT a normal, pointless count to X or from X thread! Staff told me it's fine! :D Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now