Subject Lost transference to remote database
Author Delmar Wichnieski
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]