At 07:00 PM 6/15/2001 +0200, Frank Ingermann wrote:

>... But what about the network traffic?

Somebody had to ask.

>- is the data stream from a query result sent across the wire in compressed
> form, and then decompressed by the gds32.dll on the client side, or is it
> decompressed by the server and then sent in "full length" to the client?

Full length. At the time that decision was made, it appeared that
the hardware/firmware/software that handled network issues would
include compression. A high-level software compression seemed like
a lose. I really don't know - check my previous confession on the
subject of networks - what has happened in that direction.

>This would make a great difference for the choice of data types
>(Smallint vs. Numeric(18,0) included), but esp. between Char or VarChar.

No, as it turns out, it doesn't.

>so how many bytes would go across the wire for: (assuming 1 byte per char)
>
>a) a CHAR(100) with 10 Chars (<> blank)

100 or 101 if the string is passed as a "c-string", null terminated.

>b) a CHAR(100) with 100 Chars

100 or 101 if the string is passed as a "c-string", null terminated.

>c) a VARCHAR(100) with 10 Chars

102 or 101 if the string is passed as a "c-string", null terminated.

>d) a VARCHAR(100) with 100 Chars

102 or 101 if the string is passed as a "c-string", null terminated.



Regards,

Ann
www.ibphoenix.com
We have answers.