0
6

[–] wedsa5 0 points 6 points (+6|-0) ago 

I'm not totally sure, but I imagine the 10,000 character limit covers 99.9% of all comments, and that would be the character limit set in whatever database is used to store the comment. Databases could hold longer strings, but when you set it up you have to choose some max length of characters. The devs decided to choose 10,000.

In a SQL database, a field can not have more than 65535 bytes (64KB) of data. So it depends on the character set. For regular text, each letter is 1 byte. So you could have 65535 character length. But if you use UTF8, each character is 3 bytes so you can only have 21844 characters.

https://stackoverflow.com/questions/13506832/what-is-the-mysql-varchar-max-size

0
1

[–] roznak 0 points 1 points (+1|-0) ago 

More characters means that trolls can fill the databases fast by creating giant posts through bots.

0
1

[–] OHSHITANIGGERLIED 0 points 1 points (+1|-0) ago 

Most Databases, especially primitive stuff that runs on Windows like this site does, require fixed length storage for things like posts.

A small maximum character limit allows the Databse to index fast and store efficiently.

It is a design consideration, how many users do you have, how much data can efficiently be grabbed out of the Database and displayed etc.

https://docs.microsoft.com/en-us/sql/t-sql/data-types/data-types-transact-sql

But if you want to get into it, I recommend Linux and MySQL or one of the new Database Engines to learn first.

0
4

[–] cynicaloldfart 0 points 4 points (+4|-0) ago 

primitive stuff that runs on Windows like this site does

Umm, nope. This is running on Linux now.

0
1

[–] OHSHITANIGGERLIED 0 points 1 points (+1|-0) ago 

Sweet. I thought that 404 looked like Apache.

0
1

[–] Inara__Serra 0 points 1 points (+1|-0) ago 

CockroachDB is a good place to start.

2
0

[–] wtfeva 2 points 0 points (+2|-2) ago 

Awwww. Waah.

How bout you not post a goddamned novel?

If you want to discuss, discuss. If you want to be all Mr Fucking Encyclopedia, write somewhere else and do an archive link so that we don't have to visit your faggot blog website.

[–] [deleted] 1 points 2 points (+3|-1) ago 

[Deleted]

1
0

[–] wtfeva 1 points 0 points (+1|-1) ago 

You're the fucking retard writing 10000+ character posts and crying about it being lost.

This isn't the right tool, dumbass.

Link to it.

1
0

[–] Diggernicks 1 points 0 points (+1|-1) ago 

Stop creating tl;dr posts. Get directly and efficiently to the point asap.

[–] [deleted] 1 points -1 points (+0|-1) ago 

[Deleted]

7
-7