Warning: mysqli::__construct(): (HY000/1203): User howardkn already has more than 'max_user_connections' active connections in D:\Inetpub\vhosts\howardknight.net\al.howardknight.net\includes\artfuncs.php on line 21
Failed to connect to MySQL: (1203) User howardkn already has more than 'max_user_connections' active connectionsPath: ...!news.roellig-ltd.de!open-news-network.org!weretis.net!feeder8.news.weretis.net!news.trigofacile.com!.POSTED.2001:861:3f82:d7c0:a071:713b:a7d2:e8e4!not-for-mail From: =?UTF-8?Q?Julien_=C3=89LIE?= Newsgroups: news.software.nntp Subject: Re: Improving trn: LISTGROUP with no arguments vs. ...? Date: Tue, 5 Nov 2024 21:10:55 +0100 Organization: Groupes francophones par TrigoFACILE Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Injection-Date: Tue, 5 Nov 2024 20:10:55 -0000 (UTC) Injection-Info: news.trigofacile.com; posting-account="julien"; posting-host="2001:861:3f82:d7c0:a071:713b:a7d2:e8e4"; logging-data="39806"; mail-complaints-to="abuse@trigofacile.com" User-Agent: Mozilla Thunderbird Cancel-Lock: sha1:RDKR5HCbnD5coIYXN+pcqgu0IsY= sha256:WhvTCJ+aKvD89yzgC0TqASC8zvudumMO5xWE2SsrAAw= sha1:N5e+yOYiezq/uAmJ6nQPBztDbQ8= sha256:YU8wtDS3MQ9RR/MvuOcgj9o8ygeqBhImCvKK+HveX24= In-Reply-To: Bytes: 2197 Lines: 32 Hi Richard, > It's not the algorithm that is slow per se, but asking inn for all the > article numbers in a group with thousands of articles takes quite a > long time. How much time does it take? Just tried on my own INN server: LIST COUNTS fr.soc.politique 215 Newsgroups in form "group high low count status" fr.soc.politique 2904875 2698 1365681 y .. LISTGROUP returns the 1,365,681 articles in 2,6 seconds. Not that slow... > I suspect that inn doesn't have any sort of in-memory > cache for this information and instead is directory scanning the spool > directory and reporting back the article numbers one by one. INN has the available articles and its overview database, and depending on the configuration of the server (nnrpdcheckart and groupexactcount parameters), either directly returns the information from overview or checks the article is still here. The 2,6 seconds above include the check. -- Julien ÉLIE « Ex nihilo nihil. » (Perse)