You are here: Re: Delta compression of query results « MsSQL Server « IT news, forums, messages
Re: Delta compression of query results

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.

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация