On 12/15/11 15:54, Carlos H. Cantu wrote: > Yes, but note that now my link is 20Mbits/s download: > > 1 * * * Esgotado o tempo limite do pedido. > 2 10 ms 11 ms 7 ms bd232401.virtua.com.br [189.35.36.1] > 3 8 ms 11 ms 11 ms bd07980b.virtua.com.br [189.7.152.11] > 4 10 ms 12 ms 10 ms embratel-G0-5-3-7-tacc01.cas.embratel.net.br > [200.174.243.25] > 5 134 ms 127 ms 126 ms ebt-T0-5-2-0-tcore02.cas.embratel.net.br > [200.230.252.138] > 6 131 ms 155 ms 129 ms ebt-T0-5-2-0-tcore01.spo.embratel.net.br > [200.230.252.42] > 7 176 ms 130 ms 139 ms > ebt-Bundle-POS1113-intl03.mianap.embratel.net.br > [200.230.220.62] > 8 137 ms 127 ms 144 ms ae60.edge4.Miami1.Level3.net [4.59.90.9] > 9 127 ms 125 ms 129 ms ae-2-52.edge1.Miami2.Level3.net [4.69.138.107] > 10 132 ms 132 ms 143 ms te2-5.bbr01.tm01.mia01.networklayer.com > [4.59.240.14] > 11 135 ms 128 ms 131 ms ae7.bbr01.tm01.mia01.networklayer.com > [173.192.18.174] > 12 204 ms 166 ms 162 ms ae3.bbr01.sr02.hou02.networklayer.com > [173.192.18.162] > 13 158 ms 156 ms 154 ms po31.dsr02.hstntx2.networklayer.com > [173.192.18.235] > 14 153 ms 154 ms 151 ms po15.dsr02.hstntx1.networklayer.com > [70.87.253.118] > 15 172 ms 161 ms 157 ms po2.car05.hstntx1.networklayer.com > [207.218.245.18] > 16 154 ms 155 ms 155 ms xenon.locador.com.br [75.125.222.162]
With 14 nodes between client and server that's known that we have problems. We perform too many roundtrips between client and server compared with MySQL. Possible solutions are: - modify API to have big calls (like attach database, start transaction, prepare statement and return first row - all in one call) - make client delay more packets (i.e. make it collect everything needed for a single packet representing mentioned big call from a lot of small calls) ------------------------------------------------------------------------------ Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
