compressing mysql output

is there a way to compress it?

[Namaste]

I setting up a new site on a new host, who offers a 10MBPS connection between the database server and the webserver.

Is there any way to compress the output from the MySQL database server to the webserver?

[freeflight2]

yes there is:
[us3.php.net...]

client_flags
The client_flags parameter can be a combination of the following constants: MYSQL_CLIENT_COMPRESS, ...

works similar for other languages since they all access mysql via the same API

[Namaste]

thanks, let me try this.

Are there any other optimizations that you can recommend when database server and webserver are connected over 10mbps.

Any advanced suggestions such as keeping some data on flat files on the webserver.