Subject | Re: Data packets compression |
---|---|
Author | Adam |
Post date | 2005-02-14T03:24:23Z |
You are after some sort of comms layer. We use Remobjects
(remobjects.com) to handle this. It works quite well, and takes the
stuffing around out of client-server comms.
It is often not a good idea to allow the client to run whatever SQL
they like. Although security may not be a concern in your particular
scenario, it is good to know that the only queries that are run on
the database are those queries that you have defined on the database
server. You can hide firebird from the clients. (ie block 3050 on the
firewall), and compress and encrypt the traffic.
Also keep in mind the connection failure speed if the client can not
see the server. From a windows client, it will be 21 seconds before
it decides the server is down unless you fiddle around in the
registry and reduce the retry count.
Adam
--- In firebird-support@yahoogroups.com, "Nikolay Marinov"
<kok_bg@y...> wrote:
(remobjects.com) to handle this. It works quite well, and takes the
stuffing around out of client-server comms.
It is often not a good idea to allow the client to run whatever SQL
they like. Although security may not be a concern in your particular
scenario, it is good to know that the only queries that are run on
the database are those queries that you have defined on the database
server. You can hide firebird from the clients. (ie block 3050 on the
firewall), and compress and encrypt the traffic.
Also keep in mind the connection failure speed if the client can not
see the server. From a windows client, it will be 21 seconds before
it decides the server is down unless you fiddle around in the
registry and reduce the retry count.
Adam
--- In firebird-support@yahoogroups.com, "Nikolay Marinov"
<kok_bg@y...> wrote:
>the
> 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,
> application's speed is not sufficient.
> We are using Delphi 7 and the IB components.
>
> Special thanks in advance !!!