prinnyex
Exploding Penguin
notes are just as bad because even if you trashcan them, unless you go in the trashcan and delete them, they stay there forever. Same for outbox notes.
Something We All Can Do To Help Prevent The Next Big Downtime
- Thread starter maxgoof
- Start date
notes are just as bad because even if you trashcan them, unless you go in the trashcan and delete them, they stay there forever. Same for outbox notes.
The note problem I was referring to is a different thing than what's happening now.
Nanakisan
Wild lunatic!
you'd think trash can notes would have a expiration on them.
Socks the Fox
Member
Yeah I realized a few minutes after I posted that that was what you meant. Still, I don't think that the notes themselves are as big a problem as notifications, simply because there aren't nearly as many. Plus, the solution to the notes problem could simply be to partition that table by note age. That way the DB doesn't have to search the entire table only to show the latest couple dozen. Partitioning by year aught to cut down on the load a bunch, especially with the new year coming up. Plus with partitioning, you get the benefit of not having to search through every note ever, while still getting to keep every note ever (within hard drive space limitations, of course). However, I don't know what DB software they use, or if it supports partitioning tables.
thoron
Member
Not quite as bad as note notifications are shared strictly between two users so it shouldn't explode out of control unless your a rabid RP addict or something.
Nanakisan
Wild lunatic!
Skype is such a godsend for RP'rs. Keeps really long logs for yah! But yeah i agree unlike submission notifications which is a global event to all watchers. I doubt notes alone would be cause for a DB lock up.
With Yahoo, if you are not logged in for x amount of time (three months, I think), it purges your inbox, spambox, etc, but will keep your private folders and contact lists for the yahoo messenger intact.
Having a routine check, maybe every four months or so, to see if a person has logged on at all, and if not, to do a similar purge, would get rid of ALL of the alt/abandoned/dead/banned/etc accounts.
Or maybe, instead of adding submissions to someone's submission table when someone they watch posts something, it should instead, when they log on, do a query for new submissions by the artists that person follows once they click on the submissions link, since the last time they logged on, and add that to their "submission table" instead. The downside would I guess be that instead of someone having one file, they'd essentially be doing a search each time they clicked on the submissions link, which would be kind of cloggy.
Having a routine check, maybe every four months or so, to see if a person has logged on at all, and if not, to do a similar purge, would get rid of ALL of the alt/abandoned/dead/banned/etc accounts.
Or maybe, instead of adding submissions to someone's submission table when someone they watch posts something, it should instead, when they log on, do a query for new submissions by the artists that person follows once they click on the submissions link, since the last time they logged on, and add that to their "submission table" instead. The downside would I guess be that instead of someone having one file, they'd essentially be doing a search each time they clicked on the submissions link, which would be kind of cloggy.
FoxWolfie
Pee-Stinky Raccoon
They will most likely set it as a low-priority background task, so we should not see much of an effect on the site.
I currently have only 16 messages (11S, 5J ), so the auto-purge won't even have to deal with me. I always keep my notifications as close to zero as possible.
I know that they are not purging any private notes, so people really need to take care of that on their own for now. I imagine some people have over 50,000 notes in their in-box and out-box by now. I keep mine down to where they fit on a single page. I move the rest to trash. Sometimes I'm guilty of forgetting to empty the trash. FA should consider auto-purging all trash folders after 30 days. Most online email services purge their trash folders after a certain amount of time. If people don't want something deleted, they simply don't move it to their trash. Since FA doesn't purge trash, we should be doing it ourselves. If everyone purged their own, the note system would probably be a whole lot faster.
I also clear out ancient shouts. I keep only the most recent shout from any user. Only the most recent 12 shouts are display on our pages, and the shout manager page gives us access to the most recent 25 shouts. After deleting multiples from the same user, I go to position 13 and select everything down to the last one, and remove them. I repeat until there are only 12 left, plus two or three older shouts that I've never deleted for personal reasons. Those are not seen on my page, because they end past the 12th position. Overall, at any time, there are usually around 15 total shouts in my history, as I've deleted thousands of no-longer-visible ones over the past seven years.
thoron
Member
Especially if that person hasn't been on in a while.
BakedGewds
Holly the Reindeer
I can honestly say I never have more than 200 notifs before I scan over and nuke em'. :3
*feels like a good person* aha.
Also kind of unrelated but is the main site not loading at all for anyone else?
Is that a good or bad thing?
xD
*feels like a good person* aha.
Also kind of unrelated but is the main site not loading at all for anyone else?
Is that a good or bad thing?
xD
DarkOverord
Member
prinnyex
Exploding Penguin
https://twitter.com/furaffinity
its purposely down for the last touches and such apparently, ie it'll be down until tomorrow probly :/
BakedGewds
Holly the Reindeer
Thank you, I've seen the Site Status update but that said nothing about the going in/out for an hour. I don't have a Twitter so I don't know/check updates there.
prinnyex
Exploding Penguin
omo; -SWEATS NERVOUSLY- Well i know what im doing when the site's finally back
corghi
itty bitty britty kitty.
I really really really really disagree with this. Really.
There's no reason that this website shouldn't be able to handle notifications. This reminds me back on the days of Balto Source when we had to clear out our PMs because they were slowing the site down, somehow.
If FA really can't handle notifications then, well, I think it's time for some serious renovations. That, or they implement a feature that deletes them after a certain period of time, although that'd be ridiculous.
I don't know, I just feel like we don't know the whole story. FA already knows they need to redo their system with notifications but I'm not going to be obligated to delete them.
There's no reason that this website shouldn't be able to handle notifications. This reminds me back on the days of Balto Source when we had to clear out our PMs because they were slowing the site down, somehow.
If FA really can't handle notifications then, well, I think it's time for some serious renovations. That, or they implement a feature that deletes them after a certain period of time, although that'd be ridiculous.
I don't know, I just feel like we don't know the whole story. FA already knows they need to redo their system with notifications but I'm not going to be obligated to delete them.
Blekarotva
Member
uh I can't understand why people keep their messages - unless it's note I nuke everything. I have an obession with seeing "no messages", I nuke them even when there's only "1F" xP
DarkOverord
Member
If you read Net-cat's post, they're going to be implementing an auto-delete of notifications that are more than 90 days old. It'll be implemented at some point, no idea when though, just going off the post
thoron
Member
I recall at one point they had to disable the nuke button because everyone was using it to delete even small number of notices and it was causing the system to slow down. This was back when the nuke button was first introduced though.
DarkOverord
Member
Blekarotva
Member
woah? really? That sounds, weird :V
I use more the Global select button, then nuke if favs are over 30
maxgoof
Active Member
They way I've seen it implemented elsewhere (I forget where) is that a comment can be edited until such time as it is responded to. At that point it gets frozen. It can still be deleted by the thread owner at any time.
Now, if you attempt to respond to a comment while it is being edited, you are prevented from saving your response with a note saying that it is being altered, and to wait until the altered comment is saved to respond.
Terror-Run
Well-Known Member
The global select button is made of pure love
Maybe I'll un-check one or two things before I remove stuff though.
ferretsage
Well-Known Member
9518S, 509C, 5626J, 20F, 76W
...and almost 1450 (60 per page) pages in favorites. That's about 87,000 Favorites! I use the +fav as a Facebook like button. I could live without the LARGELY UNUSED DATABASE-KILLING favorite gallery attached to my account (unused except as a backup if my hard drive tanks).
I am watching over 1,600 artists (4-5 watches a week over SEVEN YEARS). I delete 150-300 new art submission notifications EVERY DAY. Once, I left FA for a month. That's how I got the backlog of over 9,000. I thought I'd eventually get around to them, but they're just sitting there. If I ever abandoned my account (no intention to), it would quickly bog down and kill FA. No excuse for the Journals. I'll toast those as soon as I can.
...and almost 1450 (60 per page) pages in favorites. That's about 87,000 Favorites! I use the +fav as a Facebook like button. I could live without the LARGELY UNUSED DATABASE-KILLING favorite gallery attached to my account (unused except as a backup if my hard drive tanks).
I am watching over 1,600 artists (4-5 watches a week over SEVEN YEARS). I delete 150-300 new art submission notifications EVERY DAY. Once, I left FA for a month. That's how I got the backlog of over 9,000. I thought I'd eventually get around to them, but they're just sitting there. If I ever abandoned my account (no intention to), it would quickly bog down and kill FA. No excuse for the Journals. I'll toast those as soon as I can.
maxgoof
Active Member
There are plenty of things that can be improved in the coding, sure.
But in this instance, it is the notification system that we, as users, can help eliminate.
Rather than complain that the coders haven't put this one thing at the top of their todo list, above all the other things that people whine about and wonder why THAT thing isn't at the top of the todo list, why not do something positive and remove your own notifications?
Much of the complaining about this sounds like this:
"Why does the neighborhood look so crappy?"
"Well, a lot of it is the trash that is strewn everywhere. How about we all pitch in and pick it up?"
"Well...why can't the government do it??"