Re: compressed protocol

Michael Fuhr wrote:

> That's a tenuous conclusion; it assumes that the data transfer is

Are you trying to say that data won't be compressed ?

> what's taking all the time. Query planning and execution and
> client-side processing must also be taken into account. Using a
> sniffer to observe the amount of data transferred would be a more
> appropriate test.
>

From client connection:
EXPLAIN SELECT sfi,nvi,jmi FROM articles ORDER BY sif;
QUERY PLAN
------------------------------------------------------------------------------------
Index Scan using articles_pkey on articles (cost=0.00..1031.61
rows=12410 width=42)
(1 row)

So it returns 12410 rows :
sfi = INTEGER, nvi = varchar(50), jmi = varchar(3).

Yes, I know that my conclusions are tenuous, but what to say when
both tests returns result in approx. amount of time
(compressed or not).

Using compression on my nTier (kbmMW (ZLIB) ) same query returns
in 9 seconds (!=20 secs !). (same client, same server , same query).

cheers,
zac