--- In firebird-support@yahoogroups.com, "dancooperstock" <dcoops@...> wrote:

>
> I have had Firebird installed on the Linux server that serves my website, which has good speeds, and I have good up and download speeds in my Internet connection from my fast home computer (Windows 7).
>
> However, when I connect using isql on my home computer to a DB I have put on that Linux server, speeds are horrible. Running a script, that executes 8 small queries, each of which retrieves either one or just a few rows from a table (indexed properly on the key in the WHERE clause) takes one 100th of a second if I run it locally on the server, but 3-4 seconds if I run it using isql on my home computer, accessing the same DB on the server.

What version of firebird do you use ?

The protocol in Firebird 2.5 is much more improoved vs previous versions http://asfernandes.blogspot.ro/2009/07/network-latency-influence-on-firebird.html


also you need to check TcpNoNagle should be the default 1
http://www.janus-software.com/fbmanual/manual.php?book=admin&topic=43

>
> To me that just doesn't seem reasonable. The output file from those retrieves is under 50K.
>
> Similar retrieves done through the Firebird ODBC driver seem to be even slower.
>
> What should I be looking at, that might be related to this problem (or make it better)? Thanks.
>