Scratch

Here are the numbers I found with my copy of ScratchR:
25 rows in the MySQL notifications table
16 KiB of data in that table
Divide 16 by 25, and we get .64 KiB per notification.
However, then multiply by two because it also stores a copy in memcached, so you get a grand total of 1.28 KiB per notification.

While this may not seem like a lot, there are thousands of these notifications sent daily. If 2000 are sent in a day (while I'm pretty sure it's way more than that), that takes up 2.5 MiB in the database per day. While that also may not seem like a lot, if that accumulates over a year, it takes up 912.5 MiB per year (.89 GiB).

Let's go with a more realistic amount: 5K per day
1.28 KiB per notification
6.25 MiB per day
2281.25 MiB (2.22 GiB) per year

Last edited by jvvg (2013-02-24 21:59:02)

veggieman001 wrote:

jvvg wrote:

Here are the numbers I found with my copy of ScratchR:
25 rows in the MySQL notifications table
16 KiB of data in that table
Divide 16 by 25, and we get .64 KiB per notification.
However, then multiply by two because it also stores a copy in memcached, so you get a grand total of 1.28 KiB per notification.

While this may not seem like a lot, there are thousands of these notifications sent daily. If 2000 are sent in a day (while I'm pretty sure it's way more than that), that takes up 2.5 MiB in the database per day. While that also may not seem like a lot, if that accumulates over a year, it takes up 912.5 MiB per year (.89 GiB).

Let's go with a more realistic amount: 5K per day
1.28 KiB per notification
6.25 MiB per day
2281.25 MiB (2.22 GiB) per year

Which, if none were deleted, would be nearly 13 GiB total!

I'd actually guess that it'd be closer to 20 GB in total because Scratch has been open for longer then 7 years, though that's just my inference. Strangely, this doesn't seem like a lot because I do have a 32 GB flash drive and only ~4.5 GB is being used for several programs, 44 songs/ambiences, plus much more. I'm guessing the real issue is keeping track of all of those notifications.

To jvvg:
So it looks like my guess of 2~3 KB per notification, which seems exaggerated now that I re-look at it, was too high. Well thanks for showing me! I'll definitely keep this in mind as the future comes along.

With respects and thanks,

ErnieParke