On 12/14/11 20:02, Carlos H. Cantu wrote: > One year ago, when I was discussing this with Vlad, I did small > Delphi app using ZeosDB components to measure speed between FB and > MySQL similar databases with same data, hosted on remote computer and > acessing by adsl connection. Results proved that MySQL response was > much faster. From my conversation log: > > Here is results of simple stupid select * from table. Table has the > same structure for FB and MySQL, it is a customer table with 2,000 > records > > [06/12/2010 16:14:43] Opening FB Query and fetching all data () > [06/12/2010 16:15:02] End fetching FB data (19,609 sec.) > [06/12/2010 16:15:02] Opening MySQL Query and fetching all data () > [06/12/2010 16:15:05] End fetching MySQL data (3 sec.) > > So, simple stupid select took 15 seconds more in FB compared to MySQL. > > C:\Borland\Firebird21\bin>ping www.warmboot.com.br > > Ping: > > Resposta de x.x.x.x: bytes=32 tempo=166ms TTL=47 > Resposta de x.x.x.x: bytes=32 tempo=168ms TTL=47 > Resposta de x.x.x.x: bytes=32 tempo=167ms TTL=47 > Resposta de x.x.x.x: bytes=32 tempo=165ms TTL=47 > > Estatísticas do Ping para x.x.x.x: > Pacotes: Enviados = 4, Recebidos = 4, Perdidos = 0 (0% de perda), > Aproximar um número redondo de vezes em milissegundos: > Mínimo = 165ms, Máximo = 168ms, Média = 166ms > > 12MB broadband internet > 12Mb download, 800k upload > remote server is in USA
Can you also traceroute between client and server hosts? ------------------------------------------------------------------------------ 10 Tips for Better Server Consolidation Server virtualization is being driven by many needs. But none more important than the need to reduce IT complexity while improving strategic productivity. Learn More! http://www.accelacomm.com/jaw/sdnl/114/51507609/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
