When I want to see what's new on the forum, before I always used New Posts, but now I have been trying out Unread Posts.
In terms of minimising the load on the forum, which of these Quick Links is the kindest to use?
Which puts the most pressure on the forum, New Posts or Unread Posts?
Moderators: Lootyhoof, FranklinDM
-
suzyne
- Astronaut
- Posts: 687
- Joined: 2023-06-28, 22:43
- Location: Australia
Which puts the most pressure on the forum, New Posts or Unread Posts?
Laptop 1: Windows 11 64-bit, i7 @ 2.80GHz, 16GB, NVIDIA GeForce MX450.
Laptop 2: Windows 10 32-bit, Atom Z3735F @ 1.33GHz, 2GB, Intel HD Graphics.
Laptop 3: Linux Mint 20.3 64-bit, i5 @ 2.5GHz, 8GB, Intel HD Graphics 620.
Laptop 2: Windows 10 32-bit, Atom Z3735F @ 1.33GHz, 2GB, Intel HD Graphics.
Laptop 3: Linux Mint 20.3 64-bit, i5 @ 2.5GHz, 8GB, Intel HD Graphics 620.
-
Moonchild
- Pale Moon guru
- Posts: 37535
- Joined: 2011-08-28, 17:27
- Location: Motala, SE
Re: Which puts the most pressure on the forum, New Posts or Unread Posts?
I don't think there's much difference.
"A dead end street is a place to turn around and go into a new direction" - Anonymous
"Seek wisdom, not knowledge. Knowledge is of the past; wisdom is of the future." -- Native American proverb
"Linux makes everything difficult." -- Lyceus Anubite
"Seek wisdom, not knowledge. Knowledge is of the past; wisdom is of the future." -- Native American proverb
"Linux makes everything difficult." -- Lyceus Anubite
-
RealityRipple
- Keeps coming back
- Posts: 853
- Joined: 2018-05-17, 02:34
- Location: Los Berros Canyon, California
Re: Which puts the most pressure on the forum, New Posts or Unread Posts?
If it's sanely designed, it'd just be a different column for the WHERE query.
-
athenian200
- Contributing developer
- Posts: 1612
- Joined: 2018-10-28, 19:56
- Location: Georgia
Re: Which puts the most pressure on the forum, New Posts or Unread Posts?
Well, it probably doesn't make a difference, but if it did make one, I would tend to assume unread posts would be a bit more complicated simply because it has to construct which posts you individually have not read, whereas if it only needs to return new posts, it just focuses on recent datestamps that would be the same for everyone.
But then again, I don't know much about databases, what gets cached, how expensive multiple hits for a query are to display, and what is or isn't computationally expensive, so if MC says there's not much of a difference, you should probably take his word over mine, which is just a guess anyway.
But then again, I don't know much about databases, what gets cached, how expensive multiple hits for a query are to display, and what is or isn't computationally expensive, so if MC says there's not much of a difference, you should probably take his word over mine, which is just a guess anyway.
"The Athenians, however, represent the unity of these opposites; in them, mind or spirit has emerged from the Theban subjectivity without losing itself in the Spartan objectivity of ethical life. With the Athenians, the rights of the State and of the individual found as perfect a union as was possible at all at the level of the Greek spirit." -- Hegel's philosophy of Mind
-
Moonchild
- Pale Moon guru
- Posts: 37535
- Joined: 2011-08-28, 17:27
- Location: Motala, SE
Re: Which puts the most pressure on the forum, New Posts or Unread Posts?
MariaDB is exceedingly good at efficient querying, so any difference there would be, would be mostly just academic and have no real impact for something the size of a forum.
"A dead end street is a place to turn around and go into a new direction" - Anonymous
"Seek wisdom, not knowledge. Knowledge is of the past; wisdom is of the future." -- Native American proverb
"Linux makes everything difficult." -- Lyceus Anubite
"Seek wisdom, not knowledge. Knowledge is of the past; wisdom is of the future." -- Native American proverb
"Linux makes everything difficult." -- Lyceus Anubite
-
andyprough
- Board Warrior
- Posts: 1095
- Joined: 2020-05-31, 04:33
Re: Which puts the most pressure on the forum, New Posts or Unread Posts?
I had always heard that it's all the avatars (and to a lesser degree signatures) that are the bigger burden on forum software.
-
Lucio Chiappetti
- Keeps coming back
- Posts: 765
- Joined: 2014-09-01, 15:11
- Location: Milan Italy
Re: Which puts the most pressure on the forum, New Posts or Unread Posts?
Cannot comment. I kept display of avatars and signatures disabled 
The reasonable man adapts himself to the world: the unreasonable one persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. (G.B. Shaw)
-
Moonchild
- Pale Moon guru
- Posts: 37535
- Joined: 2011-08-28, 17:27
- Location: Motala, SE
Re: Which puts the most pressure on the forum, New Posts or Unread Posts?
I don't think we have to worry about what exactly is causing the most or least load per request, at least not until traffic would probably 10-fold or so...
You do not have the required permissions to view the files attached to this post.
"A dead end street is a place to turn around and go into a new direction" - Anonymous
"Seek wisdom, not knowledge. Knowledge is of the past; wisdom is of the future." -- Native American proverb
"Linux makes everything difficult." -- Lyceus Anubite
"Seek wisdom, not knowledge. Knowledge is of the past; wisdom is of the future." -- Native American proverb
"Linux makes everything difficult." -- Lyceus Anubite
-
back2themoon
- Moon Magic practitioner
- Posts: 2868
- Joined: 2012-08-19, 20:32
Re: Which puts the most pressure on the forum, New Posts or Unread Posts?
Thankfully, this remains mostly a text-driven forum.
Now imagine those abominations containing chat-boxes, all kinds of useless widgets, awards/badges/achievements every x number of posts (who the hell started this BS anyway?) with promotions and demotions, huge animated GIFs/stickers/whatever, upvotes/downvotes, music playing in the background, YouTube/Twitch embedded videos all over etc. etc.
Yuck!
Now imagine those abominations containing chat-boxes, all kinds of useless widgets, awards/badges/achievements every x number of posts (who the hell started this BS anyway?) with promotions and demotions, huge animated GIFs/stickers/whatever, upvotes/downvotes, music playing in the background, YouTube/Twitch embedded videos all over etc. etc.
Yuck!
-
moonbat
- Knows the dark side
- Posts: 5551
- Joined: 2015-12-09, 15:45
Re: Which puts the most pressure on the forum, New Posts or Unread Posts?
We do have that here
"One hosts to look them up, one DNS to find them and in the darkness BIND them."
KDE Neon on a Slimbook Excalibur (Ryzen 7 8845HS, 64 GB RAM)
AutoPageColor|PermissionsPlus|PMPlayer|Pure URL|RecordRewind|TextFX
KDE Neon on a Slimbook Excalibur (Ryzen 7 8845HS, 64 GB RAM)
AutoPageColor|PermissionsPlus|PMPlayer|Pure URL|RecordRewind|TextFX
-
suzyne
- Astronaut
- Posts: 687
- Joined: 2023-06-28, 22:43
- Location: Australia
Re: Which puts the most pressure on the forum, New Posts or Unread Posts?
No one wants to be neophyte Moongazer forever.
Laptop 1: Windows 11 64-bit, i7 @ 2.80GHz, 16GB, NVIDIA GeForce MX450.
Laptop 2: Windows 10 32-bit, Atom Z3735F @ 1.33GHz, 2GB, Intel HD Graphics.
Laptop 3: Linux Mint 20.3 64-bit, i5 @ 2.5GHz, 8GB, Intel HD Graphics 620.
Laptop 2: Windows 10 32-bit, Atom Z3735F @ 1.33GHz, 2GB, Intel HD Graphics.
Laptop 3: Linux Mint 20.3 64-bit, i5 @ 2.5GHz, 8GB, Intel HD Graphics 620.
-
moonbat
- Knows the dark side
- Posts: 5551
- Joined: 2015-12-09, 15:45
Re: Which puts the most pressure on the forum, New Posts or Unread Posts?
"One hosts to look them up, one DNS to find them and in the darkness BIND them."
KDE Neon on a Slimbook Excalibur (Ryzen 7 8845HS, 64 GB RAM)
AutoPageColor|PermissionsPlus|PMPlayer|Pure URL|RecordRewind|TextFX
KDE Neon on a Slimbook Excalibur (Ryzen 7 8845HS, 64 GB RAM)
AutoPageColor|PermissionsPlus|PMPlayer|Pure URL|RecordRewind|TextFX
-
back2themoon
- Moon Magic practitioner
- Posts: 2868
- Joined: 2012-08-19, 20:32
Re: Which puts the most pressure on the forum, New Posts or Unread Posts?
Not really what I meant though. These are simple "text categories" that occur silently and automatically in the background.
I'm talking about actual graphic badges with pop-up messages that inform you about your "promotion", urging you to achieve the next one ("10 more posts to earn the next award") etc.
"First post badge", "First like badge", "Tenth post badge", "First private message badge"... I'm sure you get the idea.