Posted by Robert Klemme on 02/14/07 16:06

On 14.02.2007 16:47, Russell Wallace wrote:
> Suppose a database server and client are separated by a low bandwidth
> link such as DSL, and the client repeatedly issues a query for, say, a
> current product list.
>
> Suppose the product list is large, but only a handful of entries have
> typically changed between queries. It would be nice if only the changes
> from last query to current one could be sent, saving bandwidth.
>
> Is there any way to do this?

Create a three tier application (instead of two tier) and do intelligent
communication with your own protocol between clients and app server.

The second best option is probably to track changes in the table (for
example by adding a timestamp column) and make sure that only changed
records get queries.

Regards

robert

[Back to original message]