Thanks for your suggestion. I think this is exactly Karsten and Mike said :
create triggers to notify the client for any kind of updates.
I'm not sure whether VB can handle such events, so I have to further study
on this.
-Jason
----- Original Message -----
From: "Claudio Lapidus" <clapidus@hotmail.com>
To: "pg" <pg@newhonest.com>; <pgsql-general@postgresql.org>
Sent: Sunday, December 07, 2003 11:09 PM
Subject: Re: [GENERAL] last update time of a table
> 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.
>
