Title: Re: Remove all alerts ?
Post by: Feline on December 21, 2017, 06:49:20 am
In this page I can setup my alerts .. but no remove button found for all the exist alerts :(
Title: Re: Remove all alerts ?
Post by: radu81 on December 21, 2017, 09:01:47 am
you can mark as read your notification, is this what you are looking for? https://www.elkarte.net/community/index.php?action=mentions select all notifications, then "Mark these mentions as read"
Title: Re: Remove all alerts ?
Post by: badmonkey on December 21, 2017, 09:16:38 am
Marking them read does not remove them. They can only be deleted individually rather than as a batch. Is that what you're asking Feline?
It would be nice if they could be batch removed, it would also be nice if admins could remove them all as well. Otherwise useless alerts accrue for years, creating a rather large database. ;)
Title: Re: Remove all alerts ?
Post by: emanuele on December 21, 2017, 09:38:38 am
If they are marked as read it is removed from the "main" page and pushed to the "read" and you have to go and for it. Isn't it?
Title: Re: Remove all alerts ?
Post by: badmonkey on December 21, 2017, 12:57:23 pm
Quote from: emanuele – If they are marked as read it is removed from the "main" page and pushed to the "read" and you have to go and for it. Isn't it?
Correct. At that point they can be deleted, but only one at a time. And admins cannot delete those of other members. ;)
Title: Re: Remove all alerts ?
Post by: Feline on December 21, 2017, 09:25:19 pm
exacly .. that's stronge to delete many, many alerts one by one :(
I Have three options on our Forum Version: 1) click to delete on a entry 2) delete all "marked" in the current page (mark all on a page with one click) 3) delete ALL alerts
Title: Re: Remove all alerts ?
Post by: emanuele on December 23, 2017, 03:30:48 pm
Quote from: badmonkey – Correct. At that point they can be deleted, but only one at a time. And admins cannot delete those of other members. ;)
Out of curiosity (just probably because I don't care about deleting things, so I'm just happy that they disappear), what is the advantage of deleting them against disappear from the view?
Title: Re: Remove all alerts ?
Post by: badmonkey on December 23, 2017, 04:40:34 pm
Quote from: badmonkey – Correct. At that point they can be deleted, but only one at a time. And admins cannot delete those of other members. ;)
Out of curiosity (just probably because I don't care about deleting things, so I'm just happy that they disappear), what is the advantage of deleting them against disappear from the view?
Minimizing database size, as a forum gets huge. ;)
Title: Re: Remove all alerts ?
Post by: Feline on December 23, 2017, 04:56:44 pm
Right .. we have ~ 5000 user .. und if they save all his alerts in the database over years ... wow ..
Wy not remove alerts they i never more need? I have notes of likes, of replies what ever .. If I read all this, I dont never more need these alerts .. so I can delete these.
Fel
Title: Re: Remove all alerts ?
Post by: emanuele on December 24, 2017, 03:16:52 am
Quote from: badmonkey – Correct. At that point they can be deleted, but only one at a time. And admins cannot delete those of other members. ;)
Out of curiosity (just probably because I don't care about deleting things, so I'm just happy that they disappear), what is the advantage of deleting them against disappear from the view?
Minimizing database size, as a forum gets huge. ;)
hmm... Db-side their size is negligible: 7 integers and a short string, for a total of 40 bytes each. Here on Elk we have ~8k that means ~320kb over about 33MB of the database. 1% at worst. If you try to save space here, you are just wasting time. ;)
ETA: the one above is true for postgre, but is an overestimation for mysql/mariadb since the integers are 2 tiny and 2 medium, so the size there should be 30 bytes instead of 40, leading to 240kb instead of 320. Then there is to add the sizes of the indexes, so 320 is still a good approximation. Of course, this table size will not increase linearly, but probably polinomially as a function of messages and active users, so on bigger forums may represent a slightly higher percentage (but on the other hand is not the only one that will grow with that function), but still not in the realm of something bigger than other tables (that cannot be pruned).
Title: Re: Remove all alerts ?
Post by: radu81 on December 24, 2017, 05:49:57 am
SMF / Elkarte are both famous for low database usage, try XF instead :o On my Elkarte 1.0.10 forum I have about 170.000 messags, 3700 users, > 10.000 attachments and the size of db is 195 MB, and 153 MB are only from the elkarte_messages table, elkarte_log_mentions is 3,2 MB, elkarte_message_likes is 2,5 MB. Different story on XF, 100.000 messages, 6200 users, 7800 attachments and total db size is 560 MB, only 52 MB are from the table of the messages, user_alert is 5,4 Mb, liked_content is 4,2 MB Similar addons on both forums, but XF saves everyhing into db, including templates, translations ...
To be honest db size is one of my last concern, both forums can run together on 5€/month VPS.
Title: Re: Remove all alerts ?
Post by: badmonkey on December 24, 2017, 08:49:52 am
I have a database that's over 1G, and that's running compressed tables. So there's that. When you have a database that size every gram counts.
In addition to the backend, the ability to batch delete represents a user friendliness feature. Now that my own account has built to 100 or so pages of these things, the thought of deleting them isn't enticing. Maybe I'm just lazy. But it's a self fulfilling prophecy. They stack up. And they stack up more because no one wants to clean that closet.
Title: Re: Remove all alerts ?
Post by: emanuele on December 24, 2017, 06:40:24 pm
Are you running 1.1 or 1.0? Out of curiosity, how many rows has the table? (log_mentions that is)