|Subject||Optimising High Latency Database Connections|
We have some customers who need to use our application, which uses Firebird, on high latency connections. What are the things that we can do to make things as good as possible for them. We have done the following:
- We are using Firebird 2.5.2 to get the new wire protocol
- We have minimised the number of queries and the fields retrieved in those queries
Are there other things that we should be doing?
I see that the configuration file allows us to change the TCP buffer size, but the discussion in #CORE-4245 makes me think that this setting will have no effect. (http://tracker.firebirdsql.org/browse/CORE-4245?page=com.atlassian.jira.plugin.system.issuetabpanels%3Aall-tabpanel)
Would changing the TcpNoNagle setting have any effect when using Classic Server on Windows? There isn't a separate wrapper program as indicated by the comments in the configuration file.
Are there other settings that would have an impact on the amount of traffic produced or on other factors that would adversely affect high latency connections?
Some additional information:
- Server uses Firebird 2.5.2 Classic Server
- Client uses Firebird 2.5.2 and Firebird 2.5.3 client libraries
- Both client and server are always on Windows platforms
- Application uses Delphi XE2 with IBObjects and DevArt dbExpress components for connecting to the database