JavaScript is required to use Bungie.net

Forums

3/15/2022 5:12:57 PM
3
The amount of [i]"technical"[/i] people in this forum who think that storing numerical values larger than 500 in a database somehow affect the processing time negatively or would require additional memory to store the data, just hurts my head. Guys, please, stop.
English

Posting in language:

 

Play nice. Take a minute to review our Code of Conduct before submitting your post. Cancel Edit Create Fireteam Post

  • 1F4 vs FA It’s an extra 4 bits. Although that doesn’t seem meaningful FF / 255 is a break point.

    Posting in language:

     

    Play nice. Take a minute to review our Code of Conduct before submitting your post. Cancel Edit Create Fireteam Post

  • First, I don't know why you are talking in hexadecimal, but sure. Second, I am not sure about your bit calculation. 8 bits are required upto 256, then upto 512, you only need 9 bits, 10 bits for 1024 and so on. I am talking about size, hence 256, values would be 0-255, as you said. Not sure what formula gave you 4 extra bits, but I use Log.base2(<int value>) then round up to find the bits required for an int value. (Do let me know how you calculated and if I am wrong, always happy to learn new stuff) Third, and the biggest point is that most DBs don't offer 9 or 10 or 12 bits datatypes. It's either TINYINT for 1 byte or SMALLINT for 2 bytes. Yes, it's true, TINYINT is indeed upto 255, but are you seriously going to argue that Bungie is so poor that they used TINYINT instead of at least, SMALLINT, if not INT? I already calculated the memory needed to store one type of mat as SMALLINT for 50 million unique accounts in a reply below and it comes out to be 95 MB. You are telling me that Bungie, a company that makes millions every year are struggling to buy/lease 47 MB / mat? Really? Does that make sense to you?

    Posting in language:

     

    Play nice. Take a minute to review our Code of Conduct before submitting your post. Cancel Edit Create Fireteam Post

  • I agree - it doesn’t seem meaningful. Your knowledge of the memory required for each type of definition exceeds mine but your logic makes sense to me. My only point was that it is a break point - probably relevant for the Commodore 64.

    Posting in language:

     

    Play nice. Take a minute to review our Code of Conduct before submitting your post. Cancel Edit Create Fireteam Post

You are not allowed to view this content.
;
preload icon
preload icon
preload icon