From owner-freebsd-doc Sat Mar 21 16:28:26 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id QAA28892 for freebsd-doc-outgoing; Sat, 21 Mar 1998 16:28:26 -0800 (PST) (envelope-from owner-freebsd-doc@FreeBSD.ORG) Received: from mail.kt.rim.or.jp (root@mail.kt.rim.or.jp [202.247.130.53]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id QAA28883; Sat, 21 Mar 1998 16:28:16 -0800 (PST) (envelope-from kuriyama@opt.phys.waseda.ac.jp) Received: from moon.opt.phys.waseda.ac.jp (ppp388.kt.rim.or.jp [202.247.140.88]) by mail.kt.rim.or.jp (8.8.5/3.4W3-rim1.1) with ESMTP id JAA28522; Sun, 22 Mar 1998 09:28:12 +0900 (JST) Received: from opt.phys.waseda.ac.jp (earth [192.168.1.2]) by moon.opt.phys.waseda.ac.jp (8.8.7/3.5Wpl4/moon-0.9) with ESMTP id XAA01390; Sat, 21 Mar 1998 23:53:40 +0900 (JST) Message-ID: <3513D44F.A6AE072F@opt.phys.waseda.ac.jp> Date: Sat, 21 Mar 1998 23:53:03 +0900 From: Jun Kuriyama X-Mailer: Mozilla 4.04 [ja] (Win95; I) MIME-Version: 1.0 To: Wolfram Schneider CC: freebsd-doc@FreeBSD.ORG, GNATS Meister Subject: Re: Slow query-pr-summary.cgi script References: <19980320144241.49293@malaria.cs.tu-berlin.de> Content-Type: text/plain; charset=iso-2022-jp Content-Transfer-Encoding: 7bit Sender: owner-freebsd-doc@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org Wolfram Schneider wrote: > query-pr-summary.cgi run 13-20 seconds for a simple request. This is > terrible slow. Sometimes it needs 150 (!!) seconds. 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 :-) Or does this delay occur suddenly? > wosch@hub <10:14:54> [~] > /usr/bin/time lynx -source http://www.freebsd.org/cgi/query-pr-summary.cgi >/dev > /null > 18.06 real 0.02 user 0.03 sys > > wosch@hub <10:40:36> [~] 514 > bash$ /usr/bin/time lynx -source http://www.freebsd.org/cgi/query-pr-summary.cgi > >/dev/null > 39.62 real 0.05 user 0.03 sys -- 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