| Subject | Very slow connection over the Internet |
|---|---|
| Author | dancooperstock |
| Post date | 2013-03-15T21:10:56Z |
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.
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.