On Thu, Dec 05, 2002 at 04:03:41PM -0600, Dan Nelson wrote:
> Protocol compression is separate from Table compression. To enable
> protocol compression, set the CLIENT_COMPRESS flag when connecting to
> the server, or add the "compress" keyword to the [client] block of your
> my.cnf file.
How ab
On Thu, 05 Dec 2002 15:36:37 -0500, Michael She wrote:
>As for indicies is it better to create a single index per column, or an
>index for a set of columns. For example, if I go: SELECT * FROM SOMETABLE
>WHERE A = X and B = Y. Is it better to create a X AND Y index, or two
>separate indicies?
In the last episode (Dec 05), Michael She said:
> I'm planning to run a remote DB across the internet for a web
> application and I would like to minimize retrival times and
> bandwidth.
>
> I have a couple of questions about MyISAM compressed Tables:
>
> 1. Is it slower to retrieve from a compre
Hi all,
I'm planning to run a remote DB across the internet for a web application
and I would like to minimize retrival times and bandwidth.
I have a couple of questions about MyISAM compressed Tables:
1. Is it slower to retrieve from a compressed table, or actually faster
since data is packed?
