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
Vlad, 06/12/2010 16:24:51:
could you edit firebird.conf at both client and server hosts and set
TcpRemoteBufferSize = 32700
?
ok, much better (but still worse than MySQL):
[06/12/2010 16:27:47] Opening FB Query and fetching all data ()
[06/12/2010 16:27:53] End fetching FB data (6,312)
[06/12/2010 16:27:53] Opening MySQL Query and fetching all data ()
[06/12/2010 16:27:56] End fetching MySQL data (2,89)
[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br
map> On Mon, Dec 12, 2011 at 2:40 PM, Carlos H. Cantu <lis...@warmboot.com.br>
wrote:
>> Hi!
>>
>> For what I'm reading, it seems that FB 3.0 has new OO API.
>>
>> Afair, in past discussions, the major "limitation" of enhancing the
>> currently FB protocol was the "old" API. So, if FB 3 will have a new
>> API (so probably component developers will have to make some changes
>> in their code to use it), isn't this the right time to enhance the
>> protocol communication speed too?
>>
>> Remember that protocol enhancement is still the most voted feature in
>> the tracker ;-)
>>
>> PS: Vlad probably wants to kill me now :)
map> Speed is one of the most important feature so i think it should be
map> pushed again and again :)
map> If you have some ideas please send them to the list even if they are
map> in Delphi (Pseudo Code)
------------------------------------------------------------------------------
Cloud Computing - Latest Buzzword or a Glimpse of the Future?
This paper surveys cloud computing today: What are the benefits?
Why are businesses embracing it? What are its payoffs and pitfalls?
http://www.accelacomm.com/jaw/sdnl/114/51425149/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
