I would imagine that if you backup without asking for verbose output (i.e. a
memo feed) there will not be any traffic back to the client...
As for the other times... maybe you have a point here

Alan

-----Original Message-----
From: nvitya [mailto:viktor.nagy@...]
Sent: Thursday, 20 March 2003 3:08 PM
To: ib-support@yahoogroups.com
Subject: [ib-support] Re: IB/FB and MySQL at low bandwidth connection

> TCPDUMP ANALYSIS OF INTERBASE QUERY RUN:
> ----------------------------------------
>
> query = "select count(*), 'RESULT' from test"
>
> Start
> client -> IB, 12 bytes
> + 065 ms
> IB -> client, 32 bytes
> + 000 ms
> client -> IB, 8 bytes
> + 050 ms
> IB -> client, 32 bytes
> + 000 ms
> client -> IB, 80 bytes with the query text
> + 059 ms
> IB -> client, 64 bytes
> + 000 ms
> client -> IB, 24 bytes
> + 049 ms
> IB -> client, 40 bytes
> + 000 ms
> client -> IB, 32 bytes
> + 083 ms
> IB -> client, 236 bytes, most of it is zero and there is a text
> "COUNT" twice
> + 000 ms
> client -> IB, 32 bytes
> + 110 ms
> IB -> client, 408 bytes, most of it is zero and there is a text
> "COUNT" twice
> + 000 ms
> client -> IB, 24 bytes
> + 048 ms
> IB -> client, 32 bytes
> + 000 ms
> client -> IB, 28 bytes
> + 058 ms
> IB -> client, 32 bytes
> + 000 ms
> client -> IB, 40 bytes
> + 084 ms
> IB -> client, 40 bytes with the text "RESULT"
>
> The total query time is 606 ms.
>
>
> ----------------------------------------------------------------
>

And additionally:

When I do remote backup (using service manager) with verbose output 30
MEGABYTES data was transmitted to the client who made the backup. The
database was 1.1M, its backup is 160 k.
I used IBConsole.
What the hell this is? Do we really need the huge amount zeros to be
transmitted?

I checked the Microsoft SQL server protocol. It has the same result as the
MySQL and PostgreSQL. Only the Interbase is slow.

Viktor



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/