Обсуждение: Efficiency

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