Subject RE: [IBO] VPN and Firebird 1.5 vs 3.0
Author Jason Wharton



The dialect between the client and the server is quite "chatty" so it isn't likely that FB3 wire compression will help tremendously.  Normally someone would use a custom data provider and custom data client that is more optimized for low latency and low bandwidth connections.  Client/server architecture is designed more with a LAN environment in mind.

You should look into setting them up with the ability to cache the schema data locally.  This would save on their startup time.

TIB_Connection has a property called SchemaCacheDir that will specify a location where these are stored.  If you do an update to your database, just delete the files there and they will automatically regenerated the next time the application runs.


Hope this helps,

Jason Wharton



From: [mailto: ]
Sent: Thursday, September 07, 2017 11:19 AM
Subject: [IBO] VPN and Firebird 1.5 vs 3.0


We have a customer who really wants to run our application over a VPN, but even with a small database it takes +4 minutes to get a open up our application. He says it runs fine once it gets going.


Can anyone tell me if FB 3.x would be any quicker? 


Much appreciated,


Ed Dressel