Received: from sardinia.gssec.bt.co.uk (sardinia.gssec.bt.co.uk [132.146.39.103]) by hub.org (8.8.8/8.7.5) with ESMTP id IAA08918 for ; Tue, 21 Jul 1998 08:33:48 -0400 (EDT) Received: from huntsville.gssec.bt.co.uk ([132.146.203.173]:1624 "HELO polkadot" ident: "IDENT-NOT-QUERIED") by sardinia.gssec.bt.co.uk with SMTP id <934729-19199>; Tue, 21 Jul 1998 13:33:20 +0100 From: "Neil Burrows" To: Subject: Efficiency Date: Tue, 21 Jul 1998 13:27:50 +0100 Message-ID: <001401bdb4a2$fa214d30$adcb9284@polkadot.gssec.bt.co.uk> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 Hi, I'm using Postgres as a backend to a web server. One particular database can only be viewed by users and not modified. When the user arrives at the site I want them to be told how many entries are in a table. This will be done using Server side includes. My question is however, is performing a COUNT operation every time a user loads a page going to be very costly in terms of CPU usage? The database will not be updated very often, so it would be possible just to update a text file holding the number of records in the table. Anyone know if the count operation would be a bad idea? Neil