Re: last update time of a table - Mailing list pgsql-general

From Claudio Lapidus
Subject Re: last update time of a table
Date
Msg-id BAY7-DAV47aLZbgYSdx0000504a@hotmail.com
Whole thread Raw
In response to last update time of a table  ("pg" <pg@newhonest.com>)
List pgsql-general
pg wrote:
> I have some pulldown menus in a VB app which extract data
> from a remote site with slow connection. And the data in those tables for
> pulldowns changes rarely. So if the pulldown has to extract the data and
> transmit it thru slow connection, the pulldown will take a few seconds to
be
> in action, which is a little bit annoying, especially if the data is the
> same as in the array of client.

Probably you'll do it better storing a local cached copy of the pulldown
data (in the VB side) and having a background process to refresh it only
when the server notifies that it has changed.

hth
cl.

pgsql-general by date:

Previous
From: Seum-Lim Gan
Date:
Subject: Re: pg_hba.conf change in 7.4
Next
From: Seum-Lim Gan
Date:
Subject: Re: pg_hba.conf change in 7.4