Thanks, I'll give it at try.
Richard
On Wed, Oct 06, 2004 at 05:14:01PM -0500, Dan Nelson wrote:
> In the last episode (Oct 06), Richard Jacobsen said:
> > I've got some large tables, ~160GB each with indexes, which are only
> > used for read only access. Since obviously all table space doesn't
> > fit in memory, Will using the compress engine speed reads/seeks on
> > these tables up at all, or will they slow them down considerably?
>
> It won't speed up seeks, but it will increase the chances that two
> nearby records are on the same disk block, potentially saving you a
> seek to fetch the 2nd one. Full table scans may be faster or slower,
> depending on your disk speed and CPU.
>
> --
> Dan Nelson
> [EMAIL PROTECTED]
>
--
"a professional is simply one who gets paid for doing what an amateur does for
love."
-- Ursula K. Le Guin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
