From owner-freebsd-doc  Sat Mar 21 16:59:55 1998
Return-Path: <owner-freebsd-doc@FreeBSD.ORG>
Received: (from majordom@localhost)
          by hub.freebsd.org (8.8.8/8.8.8) id QAA03707
          for freebsd-doc-outgoing; Sat, 21 Mar 1998 16:59:55 -0800 (PST)
          (envelope-from owner-freebsd-doc@FreeBSD.ORG)
Received: from fly.HiWAAY.net (root@fly.HiWAAY.net [208.147.154.56])
          by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id QAA03701
          for <freebsd-doc@FreeBSD.ORG>; Sat, 21 Mar 1998 16:59:52 -0800 (PST)
          (envelope-from sprice@hiwaay.net)
Received: from bonsai.hiwaay.net (tnt3-9.HiWAAY.net [208.147.146.9])
	by fly.HiWAAY.net (8.8.8/8.8.6) with SMTP id SAA17641;
	Sat, 21 Mar 1998 18:58:26 -0600 (CST)
Message-ID: <3514623B.167EB0E7@hiwaay.net>
Date: Sat, 21 Mar 1998 18:58:35 -0600
From: Steve Price <sprice@hiwaay.net>
X-Mailer: Mozilla 3.04Gold (X11; I; FreeBSD 3.0-CURRENT i386)
MIME-Version: 1.0
To: Jun Kuriyama <kuriyama@opt.phys.waseda.ac.jp>
CC: freebsd-doc@FreeBSD.ORG
Subject: Re: Slow query-pr-summary.cgi script
References: <19980320144241.49293@malaria.cs.tu-berlin.de> <3513D44F.A6AE072F@opt.phys.waseda.ac.jp>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Sender: owner-freebsd-doc@FreeBSD.ORG
Precedence: bulk
X-Loop: FreeBSD.org

Jun Kuriyama wrote:
> 
>   I felt this delay from when I used it for the first
> time (about 1 year ago).  I think this delay is normal
> operation period because hub (aka www) sometimes takes
> heavy loads and ${gnats-adm}/index has over 6000
> PRs and 400KB of size.
> 
>   To avoid this (I think) :
> 
>     1) caching result of standard queries.
>     2) optimize search routine in query-pr.
>     3) clear PRs and start from PR #1 :-)

I know this is a big problem, which I am attempting to
address along with a bunch of other big problems in
GNATS.

Having GNATS on hub is a big part of the problem.  I
would like to move GNATS to catfish, but the last time
I tried I got some errors due to its mail setup.  I
will check again shortly to see if this has been fixed.

Any suggestions or somebody willing to help hack GNATS
bits welcome. :)

Steve

>   Or does this delay occur suddenly?
> 
> --
> Jun Kuriyama // kuriyama@opt.phys.waseda.ac.jp

To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-doc" in the body of the message