Message-ID:

Man invented language to satisfy his deep need to complain. -- Lily Tomlin

rocksolid / Rocksolid Nodes Announce / expiring some articles on news.novabbs.org

expiring some articles on news.novabbs.org

<8fda24d3be3659c83fba5f58a1f9987c@rocksolidbbs.com>

https://www.rocksolidbbs.com/rocksolid/article-flat.php?id=440&group=rocksolid.nodes.announce#440

copy link Newsgroups: rocksolid.nodes.announce

Date: Tue, 1 Aug 2023 17:04:13 +0000
Subject: expiring some articles on news.novabbs.org
X-Spam-Checker-Version: SpamAssassin 4.0.0 (2022-12-13) on i2pn2.org
From: retro.guy@rocksolidbbs.com (Retro Guy)
Newsgroups: rocksolid.nodes.announce
X-Rslight-Site: $2y$10$l1y5h.tyDt/tDTIK6r1i7eWSi.S19PEJQi5Dfuw0OatAJxa6jPVJW
X-Rslight-Posting-User: 7f2224730128256930309c9186f6203084896743
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
User-Agent: Rocksolid Light 0.8.5
Organization: RetroBBS
Message-ID: <8fda24d3be3659c83fba5f58a1f9987c@rocksolidbbs.com>
X-Face: .&YR-G(w(DZ$$,}%k=]*5*!p'=(anr"IT`wZG'2VWdfl\r)l[42u7JH`n(JUQ*e5*A|XCDf
?&\X&uwkl38"CYX3O8m}C8E4p'%N$2#kSTVzx{Ly|DjLT\Vk7NE}NQ(VC$Yq]i:7|z[.9iv^g>*8_B
H0=hZt'[%)4kG|

by: Retro Guy - Tue, 1 Aug 2023 17:04 UTC

For the past couple of days, I have been pruning groups to save articles up to 90 days.

This will prune approximately 2 million posts for this run. Then it will just expire one day's postings after that (postings over 90 days old). The expirition is automatic, it just takes quite a while to expire millions of posts.

I wanted to do this as the server running news.novabbs.org is not that powerful, and wanted to see the speed changes. Also, it was a major test for rslight's expire.php program, which is performing perfectly.

Note, you can still view all these groups with much longer retention on www.novabbs.com, which has been up and running for about as long as news.novabbs.org. Note the '.org' vs. '.com'.

Right now www.novabbs.com serves approximately 3.6 million posts, and does not seem to have any trouble doing so.

Yes, I know number of active users makes a big difference, but I'm testing the db access times right now. sqlite3 is performing very nicely.

--
Retro Guy

Subject	Author
expiring some articles on news.novabbs.org	Retro Guy