Bitcoin Forum
February 18, 2020, 07:29:44 AM *
News: Latest Bitcoin Core release: 0.19.0.1 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Huge Watchlist  (Read 247 times)
qwk
Donator
Legendary
*
Offline Offline

Activity: 2394
Merit: 2437


Shitcoin Minimalist


View Profile
February 08, 2018, 07:56:21 PM
 #1

Just noticed I have a huge (as in enormous, gigantic, brobdingnagian) watchlist.
When I go to //bitcointalk.org/watchlist.php, I'm being served an html file that is over 6 MB.

Now, I think I have turned on the feature "Add posted-to topics to watchlist", but while I may post a lot, I'm still surprised.
Also, while I was checking this out, it seemed that at the moment, just any topic I read is automatically being added to my watchlist.

Somehow, I guess I either don't understand what I'm doing, or there must be something seriously wrong with my config.
I mean, 6 MB, seriously? WTF?! Shocked

All free men, wherever they may live, can use Bitcoin, and, therefore, as a free man, I take pride in the words "Ich bin ein Bitcoiner!"
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1582010984
Hero Member
*
Offline Offline

Posts: 1582010984

View Profile Personal Message (Offline)

Ignore
1582010984
Reply with quote  #2

1582010984
Report to moderator
1582010984
Hero Member
*
Offline Offline

Posts: 1582010984

View Profile Personal Message (Offline)

Ignore
1582010984
Reply with quote  #2

1582010984
Report to moderator
ibminer
Legendary
*
Offline Offline

Activity: 1446
Merit: 1698


Goonies never say die.


View Profile
February 08, 2018, 08:01:52 PM
Merited by qwk (1)
 #2

Just noticed I have a huge (as in enormous, gigantic, brobdingnagian) watchlist.
When I go to //bitcointalk.org/watchlist.php, I'm being served an html file that is over 6 MB.

Now, I think I have turned on the feature "Add posted-to topics to watchlist", but while I may post a lot, I'm still surprised.
Also, while I was checking this out, it seemed that at the moment, just any topic I read is automatically being added to my watchlist.

Somehow, I guess I either don't understand what I'm doing, or there must be something seriously wrong with my config.
I mean, 6 MB, seriously? WTF?! Shocked


Do you maybe have any "Boards" added to your watchlist?  ... which would cause all threads to be added to your watchlist under that board.
https://bitcointalk.org/watch_board.php
 

:-: Bitcointalk Public Information Project (BPIP) :-: New stats, new reports, new design, new parsers, and more!
Don't be obsessed with your desires. The Zen philosopher Basho once wrote, 'A flute with no holes, is not a flute... and a donut with no hole, is a Danish.' He was a funny guy.
qwk
Donator
Legendary
*
Offline Offline

Activity: 2394
Merit: 2437


Shitcoin Minimalist


View Profile
February 08, 2018, 08:06:55 PM
 #3

Do you maybe have any "Boards" added to your watchlist?  ... which would cause all threads to be added to your watchlist under that board.
I do. Just didn't know that's the way it worked.
Does it really add each and every single thread in these boards to the list? Damn.
I always believed that'd be more like a "select * from thread where board in watchlist" thingy.

Oh my, the more you know Roll Eyes
Now, just how do I go about cleaning my watchlist?

All free men, wherever they may live, can use Bitcoin, and, therefore, as a free man, I take pride in the words "Ich bin ein Bitcoiner!"
pugman
Legendary
*
Offline Offline

Activity: 1722
Merit: 1410


Sliding in ya DM's be like


View Profile WWW
February 08, 2018, 09:05:33 PM
 #4

Do you maybe have any "Boards" added to your watchlist?  ... which would cause all threads to be added to your watchlist under that board.
I do. Just didn't know that's the way it worked.
Does it really add each and every single thread in these boards to the list? Damn.
I always believed that'd be more like a "select * from thread where board in watchlist" thingy.

Oh my, the more you know Roll Eyes
Now, just how do I go about cleaning my watchlist?
You can clean your entire watch list by Selecting the "Mark all messages as read" option on the top right corner of the page.  And ooh, that mysql statement  Shocked

ibminer
Legendary
*
Offline Offline

Activity: 1446
Merit: 1698


Goonies never say die.


View Profile
February 08, 2018, 09:07:39 PM
Merited by mprep (1), pugman (1), marlboroza (1)
 #5

Do you maybe have any "Boards" added to your watchlist?  ... which would cause all threads to be added to your watchlist under that board.
I do. Just didn't know that's the way it worked.
Does it really add each and every single thread in these boards to the list? Damn.
I always believed that'd be more like a "select * from thread where board in watchlist" thingy.

Oh my, the more you know Roll Eyes
Now, just how do I go about cleaning my watchlist?

My understanding is that any new topic created after you've added the board should start getting added individually under your watchlist. Which I guess would be like a select * from all_threads where Board is in watchlist AND topic_replies is null  Tongue  <-no clue how the forum database is structured.
*If "Meta" was one of the watched boards, you may have seen a spike recently in new topics due to the merit system.

Are you trying to clean the watchlist or just clear it? Smiley

Clear
Edit Watchlist: https://bitcointalk.org/watchlist.php
Select All, then "Remove Checked"
*this deletes all watched threads.

Cleaning
Edit Watchlist: https://bitcointalk.org/watchlist.php
Good luck with the checkboxes.
Click "Removed Checked"

... and obviously unwatch any boards you do not want feeding into your watchlist.

You can clean your entire watch list by Selecting the "Mark all messages as read" option on the top right corner of the page.  And ooh, that mysql statement  Shocked

This would clear the unread messages of the topics/board, but topics would stay as part of your watchlist and show any new replies to those threads.


:-: Bitcointalk Public Information Project (BPIP) :-: New stats, new reports, new design, new parsers, and more!
Don't be obsessed with your desires. The Zen philosopher Basho once wrote, 'A flute with no holes, is not a flute... and a donut with no hole, is a Danish.' He was a funny guy.
pugman
Legendary
*
Offline Offline

Activity: 1722
Merit: 1410


Sliding in ya DM's be like


View Profile WWW
February 08, 2018, 09:16:37 PM
 #6

Do you maybe have any "Boards" added to your watchlist?  ... which would cause all threads to be added to your watchlist under that board.
I do. Just didn't know that's the way it worked.
Does it really add each and every single thread in these boards to the list? Damn.
I always believed that'd be more like a "select * from thread where board in watchlist" thingy.

Oh my, the more you know Roll Eyes
Now, just how do I go about cleaning my watchlist?

My understanding is that any new topic created after you've added the board should start getting added individually under your watchlist. Which I guess would be like a select * from all_threads where Board is in watchlist AND topic_replies is null  Tongue
*If "Meta" was one of the watched boards, you may have seen a spike recently in new topics due to the merit system.

Are you trying to clean the watchlist or just clear it? Smiley

Clear
Edit Watchlist: https://bitcointalk.org/watchlist.php
Select All, then "Remove Checked"

Cleaning
Edit Watchlist: https://bitcointalk.org/watchlist.php
Good luck with the checkboxes.
Click "Removed Checked"

... and obviously unwatch any boards you do not want feeding into your watchlist.

You can clean your entire watch list by Selecting the "Mark all messages as read" option on the top right corner of the page.  And ooh, that mysql statement  Shocked

This would clear the unread messages of the topics/board, but topics would stay as part of your watchlist and show any new replies to those threads.
What is the difference between https://bitcointalk.org/watchlist.php and https://bitcointalk.org/index.php?action=watchlist? They have totally different formatting and background but they are watch lists at the end of the day.  Huh

ibminer
Legendary
*
Offline Offline

Activity: 1446
Merit: 1698


Goonies never say die.


View Profile
February 08, 2018, 09:19:06 PM
Merited by pugman (1)
 #7

What is the difference between https://bitcointalk.org/watchlist.php and https://bitcointalk.org/index.php?action=watchlist? They have totally different formatting and background but they are watch lists at the end of the day.  Huh

The way I look at it:
Edit watchlist: https://bitcointalk.org/watchlist.php
View watchlist: https://bitcointalk.org/index.php?action=watchlist

View would show any topics in your watchlist that have new unread replies.
Edit shows all topics in your watchlist... just because it isn't appearing under the "View", doesn't mean it isn't part of your watchlist - waiting to appear when a new reply is added.

:-: Bitcointalk Public Information Project (BPIP) :-: New stats, new reports, new design, new parsers, and more!
Don't be obsessed with your desires. The Zen philosopher Basho once wrote, 'A flute with no holes, is not a flute... and a donut with no hole, is a Danish.' He was a funny guy.
pugman
Legendary
*
Offline Offline

Activity: 1722
Merit: 1410


Sliding in ya DM's be like


View Profile WWW
February 08, 2018, 09:23:14 PM
 #8

What is the difference between https://bitcointalk.org/watchlist.php and https://bitcointalk.org/index.php?action=watchlist? They have totally different formatting and background but they are watch lists at the end of the day.  Huh

The way I look at it:
Edit watchlist: https://bitcointalk.org/watchlist.php
View watchlist: https://bitcointalk.org/index.php?action=watchlist

View would show any topics in your watchlist that have new unread replies.
Edit shows all topics in your watchlist... just because it isn't appearing under the "View", doesn't mean it isn't part of your watchlist - waiting to appear when a new reply is added.
Now I get it. Seems to be pretty simple but confusing in the first place. But anyhow, thank  you.

qwk
Donator
Legendary
*
Offline Offline

Activity: 2394
Merit: 2437


Shitcoin Minimalist


View Profile
February 08, 2018, 10:37:07 PM
 #9

Clear
Edit Watchlist: https://bitcointalk.org/watchlist.php
Select All, then "Remove Checked"
*this deletes all watched threads.
Unfortunately, when I do that, it only cleans out a few hundred or thousand watched threads at a time. I guess there's a limit with the processing of "ticked boxes" in the POST or something. From testing I noticed I get the size of the list down by 0.2 MB every time I do that. So, I'll probably have to reload that page some 30 times or so Roll Eyes
Well, at least I'm getting somewhere Grin

All free men, wherever they may live, can use Bitcoin, and, therefore, as a free man, I take pride in the words "Ich bin ein Bitcoiner!"
qwk
Donator
Legendary
*
Offline Offline

Activity: 2394
Merit: 2437


Shitcoin Minimalist


View Profile
February 08, 2018, 10:51:03 PM
 #10

I always believed that'd be more like a "select * from thread where board in watchlist" thingy.
And ooh, that mysql statement
Apart from the "*" I'd certainly not use in a production environment and a missing "where user = ?", what about my SQL-statement?
Not that I put a lot of detailed thought into it, but I also don't see anything wrong with it Huh
Assuming "thread", "board" and "watchlist" are proper views, of course Smiley

Obviously, it was only meant to demonstrate my assumptions about the mechanics of the "watch board".
I just don't see why that should actually add records to my watchlist. But it seems to do. Roll Eyes

All free men, wherever they may live, can use Bitcoin, and, therefore, as a free man, I take pride in the words "Ich bin ein Bitcoiner!"
ibminer
Legendary
*
Offline Offline

Activity: 1446
Merit: 1698


Goonies never say die.


View Profile
February 09, 2018, 04:57:03 PM
Last edit: February 09, 2018, 05:07:50 PM by ibminer
Merited by qwk (1)
 #11

Clear
Edit Watchlist: https://bitcointalk.org/watchlist.php
Select All, then "Remove Checked"
*this deletes all watched threads.
Unfortunately, when I do that, it only cleans out a few hundred or thousand watched threads at a time. I guess there's a limit with the processing of "ticked boxes" in the POST or something. From testing I noticed I get the size of the list down by 0.2 MB every time I do that. So, I'll probably have to reload that page some 30 times or so Roll Eyes
Well, at least I'm getting somewhere Grin

There are limitations you could be running into from PHP, I know there is a setting somewhere (Google told me max_input_vars Cheesy).
Default value appears to be 1,000 so assuming the default is set on this forum, we can estimate you had over 30,000 topics??  Shocked

Regarding the query, it was valid and obviously a little tongue-in-cheek but I am (was?) a little confused by what you were expecting this feature to do?  Based on your query "select * from thread where board in watchlist", I first interpreted this as being run from a global perspective (assuming "threads" was a table of every thread on the forum) and returning all threads where that threads respective "board" is in your board watchlist... which is sort of what it does, it just limits it to new topics in those boards.

I have a feeling my confusion was that your example query was meant to be executed on your own watchlist?  which would make it more of a "select * from threadsinmywatchlist where board in mywatchboard". In which case, I assume there would need to be another 'view' page or some sort of "Only show threads in my watch board" checkbox to filter only threads in your watchlist that are part of boards added in your "watch board"?  This would allow the 'watch board' to still function the way it does, but give an option to filter the view of the watchlist to only threads part of boards in the "watch board".

Not sure if I'd find this useful but it might be helpful for people who post all over the forum but want a way to quickly filter the watchlist view to only topics that are part of boards in their "watch board"?



:-: Bitcointalk Public Information Project (BPIP) :-: New stats, new reports, new design, new parsers, and more!
Don't be obsessed with your desires. The Zen philosopher Basho once wrote, 'A flute with no holes, is not a flute... and a donut with no hole, is a Danish.' He was a funny guy.
qwk
Donator
Legendary
*
Offline Offline

Activity: 2394
Merit: 2437


Shitcoin Minimalist


View Profile
February 09, 2018, 05:45:41 PM
 #12

Clear
Edit Watchlist: https://bitcointalk.org/watchlist.php
Select All, then "Remove Checked"
Unfortunately, when I do that, it only cleans out a few hundred or thousand watched threads at a time. I guess there's a limit with the processing of "ticked boxes" in the POST or something. From testing I noticed I get the size of the list down by 0.2 MB every time I do that. So, I'll probably have to reload that page some 30 times or so Roll Eyes
There are limitations you could be running into from PHP, I know there is a setting somewhere (Google told me max_input_vars Cheesy).
Default value appears to be 1,000 so assuming the default is set on this forum, we can estimate you had over 30,000 topics??  Shocked
Good news, everyone: I cleared my watchlist. Well, if PHP has such a limitation, I guess that was the reason Roll Eyes
I didn't count how many times I reloaded, but I guess that, yes, something on the order of 30.000 topics could possibly have been on my list Cool

Regarding the query, it was valid and obviously a little tongue-in-cheek but I am (was?) a little confused by what you were expecting this feature to do?  Based on your query "select * from thread where board in watchlist", I first interpreted this as being run from a global perspective (assuming "threads" was a table of every thread on the forum) and returning all threads where that threads respective "board" is in your board watchlist... which is sort of what it does, it just limits it to new topics in those boards.
Well, I assume that somehow there's a table called "watched_threads" with records like "user, thread". This is where a "thread id" goes whenever I click "watch" on a thread.
I also assumed that whenever I watched a whole board, there'd be a table called "watched_boards" with records like "user, board", where only the "board id" goes.
Then, whenever I'd look at my watchlist, it would simply look for all new posts in "watched_threads" as well as any new posts in "watched_boards".
I just did not assume that, in fact, every single new thread in a watched board would be automatically inserted into my "watched_threads".

See the difference?
In one case, "watched_threads" would stay relatively small, in the other case, it'd quickly blow up over time.
Sure, with "my" method, the query behind "watchlist" would be slightly more complex.

All free men, wherever they may live, can use Bitcoin, and, therefore, as a free man, I take pride in the words "Ich bin ein Bitcoiner!"
mlgblockchain
Jr. Member
*
Offline Offline

Activity: 136
Merit: 1


View Profile
February 09, 2018, 06:01:56 PM
 #13

You got a huge activity number. Mine is nothing compared to you. That's why my watchlist is very little. Matter of fact, there's not even 10 posts there. And interestingly, I'm on the same train as you are. I don't know how I got these 9. I mean I don't know my config either.
matrixx
Newbie
*
Offline Offline

Activity: 35
Merit: 0


View Profile
February 09, 2018, 06:14:34 PM
 #14

Just noticed I have a huge (as in enormous, gigantic, brobdingnagian) watchlist.
When I go to //bitcointalk.org/watchlist.php, I'm being served an html file that is over 6 MB.

Now, I think I have turned on the feature "Add posted-to topics to watchlist", but while I may post a lot, I'm still surprised.
Also, while I was checking this out, it seemed that at the moment, just any topic I read is automatically being added to my watchlist.

Somehow, I guess I either don't understand what I'm doing, or there must be something seriously wrong with my config.
I mean, 6 MB, seriously? WTF?! Shocked

how many topics you usually read ?? might be all because you read so much.
Thirdspace
Hero Member
*****
Offline Offline

Activity: 1232
Merit: 720


Mixing reinvented for your privacy | chipmixer.com


View Profile
February 10, 2018, 09:33:07 AM
 #15

You can clean your entire watch list by Selecting the "Mark all messages as read" option on the top right corner of the page.  And ooh, that mysql statement  Shocked

This would clear the unread messages of the topics/board, but topics would stay as part of your watchlist and show any new replies to those threads.

is there a way to "permanently" clean my watchlist?
as in permanently never give me notice anymore if there's new replies to those threads
I would like to "ignore" some of the irrelevant old threads in my watchlist

pugman
Legendary
*
Offline Offline

Activity: 1722
Merit: 1410


Sliding in ya DM's be like


View Profile WWW
February 10, 2018, 10:24:30 AM
 #16

You can clean your entire watch list by Selecting the "Mark all messages as read" option on the top right corner of the page.  And ooh, that mysql statement  Shocked

This would clear the unread messages of the topics/board, but topics would stay as part of your watchlist and show any new replies to those threads.

is there a way to "permanently" clean my watchlist?
as in permanently never give me notice anymore if there's new replies to those threads
I would like to "ignore" some of the irrelevant old threads in my watchlist
I think this should help. https://bitcointalk.org/index.php?action=profile;u=338591;sa=notification , as in your case,deselect  the first checkbox,
If not,just go here :- https://bitcointalk.org/watchlist.php ; select all of them and remove them ,though I believe this is temporary.

ibminer
Legendary
*
Offline Offline

Activity: 1446
Merit: 1698


Goonies never say die.


View Profile
February 11, 2018, 12:56:04 PM
 #17

Well, I assume that somehow there's a table called "watched_threads" with records like "user, thread". This is where a "thread id" goes whenever I click "watch" on a thread.
I also assumed that whenever I watched a whole board, there'd be a table called "watched_boards" with records like "user, board", where only the "board id" goes.
Then, whenever I'd look at my watchlist, it would simply look for all new posts in "watched_threads" as well as any new posts in "watched_boards".
I just did not assume that, in fact, every single new thread in a watched board would be automatically inserted into my "watched_threads".

See the difference?
In one case, "watched_threads" would stay relatively small, in the other case, it'd quickly blow up over time.
Sure, with "my" method, the query behind "watchlist" would be slightly more complex.

I believe I see the difference, and this is probably how I would imagine the basic structure of the tables as well. Assuming this was how it worked, how would the forum know which thread(s) in a board to add or show in your watchlist after you have added a board to "watch board"?  If the answer is "any topic I've posted to within that board", wouldn't these threads already be getting added with the "automatically add threads I've posted to" checkbox and make this somewhat redundant?

Would your intent be that you could unwatch a thread you have posted in, but still have it appear in the watchlist because that thread is under a board in your watch board list?

I may be over(or under)thinking this. Smiley 

is there a way to "permanently" clean my watchlist?
as in permanently never give me notice anymore if there's new replies to those threads
I would like to "ignore" some of the irrelevant old threads in my watchlist

It sounds like you just want to remove them from your watchlist, use "Edit Watchlist" and check off the threads you do not want to show up - then "Remove checked"

:-: Bitcointalk Public Information Project (BPIP) :-: New stats, new reports, new design, new parsers, and more!
Don't be obsessed with your desires. The Zen philosopher Basho once wrote, 'A flute with no holes, is not a flute... and a donut with no hole, is a Danish.' He was a funny guy.
Thirdspace
Hero Member
*****
Offline Offline

Activity: 1232
Merit: 720


Mixing reinvented for your privacy | chipmixer.com


View Profile
February 11, 2018, 02:26:28 PM
 #18

It sounds like you just want to remove them from your watchlist, use "Edit Watchlist" and check off the threads you do not want to show up - then "Remove checked"
I want to unwatch them, as in no longer listed/showed under my watchlist when new replies posted
I (think) have tried this before but it only removes them temporarily from the list.
I'm going to try again today, I will try "Select all" then "Remove checked"

anyway to control what will be shown on unreadreplies page, such as some filtering to ignore very old threads?

ibminer
Legendary
*
Offline Offline

Activity: 1446
Merit: 1698


Goonies never say die.


View Profile
February 11, 2018, 03:26:21 PM
 #19

It sounds like you just want to remove them from your watchlist, use "Edit Watchlist" and check off the threads you do not want to show up - then "Remove checked"
I want to unwatch them, as in no longer listed/showed under my watchlist when new replies posted
I (think) have tried this before but it only removes them temporarily from the list.
I'm going to try again today, I will try "Select all" then "Remove checked"

anyway to control what will be shown on unreadreplies page, such as some filtering to ignore very old threads?

As long as they've been removed from the "Edit watchlist" area, they shouldn't get added back in unless you re-watch the thread or reply in the same thread again (assuming "Automatically watch topics after replying to them" is enabled on your account). Reading all posts in the thread will temporarily remove it from the watchlist view but a new reply will make it re-appear.

:-: Bitcointalk Public Information Project (BPIP) :-: New stats, new reports, new design, new parsers, and more!
Don't be obsessed with your desires. The Zen philosopher Basho once wrote, 'A flute with no holes, is not a flute... and a donut with no hole, is a Danish.' He was a funny guy.
Pages: [1]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!