Hi!
Databases contain lot of char(n) type fields containing ascii characters.
Most of fields contain less characters than field width.
Changing them to varchar is not easy.
Database is accessed from Debian Postgres 12.2 over internet using psqlodbc
with
TLS v1.3.
Mostly results seelct commands are sent and results are retrieved.
Clients have 10-20Mbit download speeds, and 5-20 Mbit upload speeds.
Will data compression increase speed ?
If yes, how to implement this ?
Andrus.