fabiano_bonin wrote:

>--- In Firebird-Architect@yahoogroups.com, "Paul Beach" <pbeach@i...>
>wrote:
>
>
>>I have been looking at / considering what improvements - if any
>>we should make to the remote protocol.. From an IBReplicator perspective
>>I know that the conversations between client/server and back are
>>pretty chatty, by that I mean there is a lot of too and from
>>
>>
>conversation.
>
>
>>Over a WAN this slows down replication to what some users would consider
>>an unreasonable degree...
>>
>>As such I am looking for any specific information/measurements that
>>any of you may have done that define the "problems" before I start
>>having to do this myself. i.e how talkative is Firebird for example
>>in comparison to other databases?
>>
>>How many messages get sent to perform simple operations e.g. a singleton
>>select, update, insert etc, does anybody have any statistics?
>>
>>
>
>Paul, some time ago i did some measurements because i was having
>problems with speed across WAN lines.
>
>I don't have the numbers anymore, but i remember that to make a simple
>connection to a database i had 6 or 7 roundtrips (or more). If i
>remember correctly, selects, updates and inserts did lots of
>roundtrips also.
>
>If you need i can try to measure them again. At that time i was using
>Ethereal to do the task.
>
>I came from SQL server and never had measured it's performance, but
>what i can say in pratical terms is that my application was able to
>run across WAN lines in a satisfactory way when using SQL Server, but
>it's not viable with Firebird. The difference in time to make the same
>operations was FB being 5 to 10 times slower than SQL Server.
>
>Today i solved those speed problems using replication, and even if FB
>improves a lot its actual speed, i will continue to use replication
>for many other reasons that you know better than i, but i miss a lot a
>better performance of FB protocol when i have to maintain some remote
>customer server, what is an usual task in my company.
>
>

I also implemented replication for the same reasons, and feel the same
way. My application was barely usable over the WAN... Now, using
replication of course, it's not so big a problem: a complete replication
cycle usually takes somewhere between 30 and 60 seconds (though,
obviously, it does vary a lot in both directions). But even if/when it's
a bit slower (a couple minutes), it doesn't make any significant
difference for my customer, since they aren't using the application
directly over the WAN. Still, I agree that the remote protocol is
something that ought to get looked at.
--

Best regards,
Jonathan Neve
_______________
CopyTiger - advanced database replicator for Interbase/Firebird!
Web : http://www.microtec.fr/copycat/ct
_______________________________________
CopyCat - database replication components for Delphi/C++Builder!
Web : http://www.microtec.fr/copycat/cc



[Non-text portions of this message have been removed]