Message-ID:

Blinding speed can compensate for a lot of deficiencies. -- David Nichols

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

expiring some articles on news.novabbs.org

<8fda24d3be3659c83fba5f58a1f9987c@rocksolidbbs.com>

https://news.novabbs.org/computers/article-flat.php?id=442&group=rocksolid.nodes.announce#442

copy link Newsgroups: rocksolid.nodes.announce

Path: i2pn2.org!.POSTED!not-for-mail
From: retro.guy@rocksolidbbs.com (Retro Guy)
Newsgroups: rocksolid.nodes.announce
Subject: expiring some articles on news.novabbs.org
Date: Tue, 1 Aug 2023 17:04:13 +0000
Organization: RetroBBS
Message-ID: <8fda24d3be3659c83fba5f58a1f9987c@rocksolidbbs.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Info: i2pn2.org;
logging-data="1041386"; mail-complaints-to="usenet@i2pn2.org";
posting-account="qk6pvs/sIyKYNRNFdjVS+ghlZZkCUq7cWs+7p7kaLpU";
User-Agent: Rocksolid Light 0.8.5
X-Rslight-Site: $2y$10$l1y5h.tyDt/tDTIK6r1i7eWSi.S19PEJQi5Dfuw0OatAJxa6jPVJW
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|
X-Rslight-Posting-User: 7f2224730128256930309c9186f6203084896743
X-Spam-Checker-Version: SpamAssassin 4.0.0 (2022-12-13) on i2pn2.org

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