Messaging System By HullBreach

By @HullBreach Premium64

POSTED: 15 Jan 2014 00:34
CATEGORY: This Community
FEATURED: Yes (@HullBreach Premium64

I'm working on updating the database structure of the messaging system. You may notice a temporary outage of message viewing while this goes on. Hopefully, everything will be much faster in the end, once 2.8M messages on 800MB hard disk space (MySQL database table) are processed.

UPDATE
I believe everything is ready, now. The body component of messages has been split into a separate database table that is only accessed when reading or composing messages. Let me know if you see any errors moving forward.

+17 -0

Samurai Bob
16 Jan 2014 01:27

I'M GOING TO MESSAGE EVERYONE.

PLAINOLDLUIS
16 Jan 2014 06:18
In reply to Samurai Bob

You sure in heck ain't mailing me.

Monstercat
15 Jan 2014 01:41

2.6 million messages on 1 GB? How?

NillocSkywalker
15 Jan 2014 01:46
In reply to Monstercat

compress.txt

Monstercat
16 Jan 2014 03:32
In reply to NillocSkywalker

I knew that, but I still find it hard to believe that 2.6 million messages (for example, assuming each is about 200 bytes) fits into 1 GB, even if it is compressed.

NillocSkywalker
16 Jan 2014 04:14
In reply to Monstercat

Life is hard to believe, too.

PLAINOLDLUIS
15 Jan 2014 01:40

Yep. No more problems. I'm not seeing any problems.