Re: last update time of a table
От | pg |
---|---|
Тема | Re: last update time of a table |
Дата | |
Msg-id | 005c01c3bd3d$6bb53bc0$2101a8c0@jasonnb обсуждение исходный текст |
Ответ на | last update time of a table ("pg" <pg@newhonest.com>) |
Список | pgsql-general |
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. >
В списке pgsql-general по дате отправления: