Re: last update time of a table

From: "Claudio Lapidus" <clapidus(at)hotmail(dot)com>
To: "pg" <pg(at)newhonest(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: last update time of a table
Date: 2003-12-07 15:09:32
Message-ID: BAY7-DAV47aLZbgYSdx0000504a@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2003-12-07 16:02:01 Re: user defined variable per session
Previous Message Seum-Lim Gan 2003-12-07 14:48:19 Re: pg_hba.conf change in 7.4