Subject | Lost transference to remote database |
---|---|
Author | Delmar Wichnieski |
Post date | 2004-12-06T19:34:46Z |
Hi all
I am working in a system (with 7 Delphi and Firebird 1,5) that it
makes a remote connection enters my local data base and a data base
web by ADSL 600 Kbps. This connection make operations of
insert, update and delete in remote database. For the connection I use the components of
the IB_Query, Ib_Connection and Ib_Dsql. My connection starts in measured 3k, but after 15 minutes it
starts to fall until below of 1k where it is until the operations to
finish. This is very slow. But results with tracert to our datacenter host indicate best connection.
For local transference test using a 100 Mbps network, this same system reaches 200 Kpbs.
This is normal? How I can improve the
best tax transference?
Results of tracer
First---------------------------------------------------------------------------------------------------------------------------------------
Rastreando a rota para firebird.hostsul.com.br [200.155.13.10]
com no máximo 30 saltos:
1 <1 ms 1 ms <1 ms 10.1.1.1
2 27 ms 47 ms 52 ms 200.180.143.225
3 34 ms 63 ms 25 ms BrT-G3-1-751-paecore01.brasiltelecom.net.br [201.10.254.133]
4 115 ms 108 ms 49 ms BrT-G6-0-0-paeborder.brasiltelecom.net.br [201.10.225.30]
5 47 ms 53 ms 41 ms 200.248.240.33
6 80 ms 87 ms 77 ms ebt-A10-0-2-core01.spo.embratel.net.br [200.230.0.194]
7 49 ms 66 ms 62 ms 200.230.243.15
8 148 ms 83 ms 81 ms condominio-A1-0-57-dist04.spo.embratel.net.br [200.228.240.154]
9 90 ms 113 ms 146 ms 200.198.191.246
10 200.155.13.10 relat¢rios: Protocolo de destino inacess¡vel.
Second---------------------------------------------------------------------------------------------------------------------------------
Rastreando a rota para firebird.hostsul.com.br [200.155.13.10]
com no máximo 30 saltos:
1 <1 ms <1 ms <1 ms 10.1.1.1
2 38 ms 79 ms 69 ms 200.180.143.225
3 59 ms 131 ms 100 ms BrT-G3-1-751-paecore01.brasiltelecom.net.br [201.10.254.133]
4 331 ms 227 ms 365 ms BrT-G6-0-0-paeborder.brasiltelecom.net.br [201.10.225.30]
5 448 ms 446 ms 295 ms 200.248.240.33
6 78 ms 84 ms 80 ms ebt-A10-0-2-core01.spo.embratel.net.br [200.230.0.194]
7 93 ms 92 ms 47 ms 200.230.243.15
8 328 ms 456 ms 481 ms condominio-A1-0-57-dist04.spo.embratel.net.br [200.228.240.154]
9 199 ms * 91 ms 200.198.191.246
10 200.155.13.10 relat¢rios: Protocolo de destino inacess¡vel.
---------------------------------------------------------------------------------------------
Regards for any comment
Delmar
[Non-text portions of this message have been removed]
I am working in a system (with 7 Delphi and Firebird 1,5) that it
makes a remote connection enters my local data base and a data base
web by ADSL 600 Kbps. This connection make operations of
insert, update and delete in remote database. For the connection I use the components of
the IB_Query, Ib_Connection and Ib_Dsql. My connection starts in measured 3k, but after 15 minutes it
starts to fall until below of 1k where it is until the operations to
finish. This is very slow. But results with tracert to our datacenter host indicate best connection.
For local transference test using a 100 Mbps network, this same system reaches 200 Kpbs.
This is normal? How I can improve the
best tax transference?
Results of tracer
First---------------------------------------------------------------------------------------------------------------------------------------
Rastreando a rota para firebird.hostsul.com.br [200.155.13.10]
com no máximo 30 saltos:
1 <1 ms 1 ms <1 ms 10.1.1.1
2 27 ms 47 ms 52 ms 200.180.143.225
3 34 ms 63 ms 25 ms BrT-G3-1-751-paecore01.brasiltelecom.net.br [201.10.254.133]
4 115 ms 108 ms 49 ms BrT-G6-0-0-paeborder.brasiltelecom.net.br [201.10.225.30]
5 47 ms 53 ms 41 ms 200.248.240.33
6 80 ms 87 ms 77 ms ebt-A10-0-2-core01.spo.embratel.net.br [200.230.0.194]
7 49 ms 66 ms 62 ms 200.230.243.15
8 148 ms 83 ms 81 ms condominio-A1-0-57-dist04.spo.embratel.net.br [200.228.240.154]
9 90 ms 113 ms 146 ms 200.198.191.246
10 200.155.13.10 relat¢rios: Protocolo de destino inacess¡vel.
Second---------------------------------------------------------------------------------------------------------------------------------
Rastreando a rota para firebird.hostsul.com.br [200.155.13.10]
com no máximo 30 saltos:
1 <1 ms <1 ms <1 ms 10.1.1.1
2 38 ms 79 ms 69 ms 200.180.143.225
3 59 ms 131 ms 100 ms BrT-G3-1-751-paecore01.brasiltelecom.net.br [201.10.254.133]
4 331 ms 227 ms 365 ms BrT-G6-0-0-paeborder.brasiltelecom.net.br [201.10.225.30]
5 448 ms 446 ms 295 ms 200.248.240.33
6 78 ms 84 ms 80 ms ebt-A10-0-2-core01.spo.embratel.net.br [200.230.0.194]
7 93 ms 92 ms 47 ms 200.230.243.15
8 328 ms 456 ms 481 ms condominio-A1-0-57-dist04.spo.embratel.net.br [200.228.240.154]
9 199 ms * 91 ms 200.198.191.246
10 200.155.13.10 relat¢rios: Protocolo de destino inacess¡vel.
---------------------------------------------------------------------------------------------
Regards for any comment
Delmar
[Non-text portions of this message have been removed]