Posted by BJMurphy on 02/14/07 16:15

On Feb 14, 10:47 am, Russell Wallace <russell.no.s...@gmail.com>
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?
>
> Thanks,
>
> --
> "Always look on the bright side of life."
> To reply by email, replace no.spam with my last name.

Not sure if this is what you mean, but you could make a second/table
or view on the database server with all the entries and the data that
has been sent to the client. Then, you could screen this table for
differences with the existing/current product table and get a subset
of rows to send to the client.

[Back to original message]