On 15-3-2013 22:10, dancooperstock 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.
>
> 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.

The Firebird wire protocol does not perform well over higher latency
connections, like over the internet.

Also, are you implying that your server is directly open and available
on the internet? You might want to consider only allowing web-traffic
and SSH and closing off everything else.

You could consider connecting with SSH and executing the script locally.

Mark
--
Mark Rotteveel