Subject | Re: [firebird-support] Data packets compression |
---|---|
Author | David Johnson |
Post date | 2005-02-14T03:05:07Z |
You may need to apply a midware facade layer between the database and
the application. The purpose of the facade is to issue short commands
and supply compressed (gzipped?) data streams between the server and the
desktop. Application of the facade alone reduced the byte count from
over 100K to under 5K for a delphi C/S application (based on DB2, not
Firebird). GZip could typically achieve another 80% compression to 1K.
SQL server interfaces are not designed for heavy traffic on slow
connections.
the application. The purpose of the facade is to issue short commands
and supply compressed (gzipped?) data streams between the server and the
desktop. Application of the facade alone reduced the byte count from
over 100K to under 5K for a delphi C/S application (based on DB2, not
Firebird). GZip could typically achieve another 80% compression to 1K.
SQL server interfaces are not designed for heavy traffic on slow
connections.
On Sun, 2005-02-13 at 17:01, Nikolay Marinov wrote:
>
>
>
> Hi All
> We develop a large application, which will be over slow internet
> connection accessed (3-6k) .
> Current FB version is 1.5 on Slackware Linux installed.
>
> Is there anyone who was able successfully to compress the data
> packets between the server and the clients?
> Is there any application that can make this?
> Which firebird.conf options should i change to improve the
> performance?
>
> The application is designed for such purposes, all of the queries
> are restricted and does not returns a large data, but even that, the
> application's speed is not sufficient.
> We are using Delphi 7 and the IB components.
>
> Special thanks in advance !!!
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>