--- 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.

Regards,

Fabiano.

> Has anybody run into other issues with the remote protocol that bear

looking

> at?
>
> Paul Beach
> Main Tel (UK):+44 (0) 1844 354357
> Mobile: (UK): +44 (0) 7837 898072
>