List:General Discussion« Previous MessageNext Message »
From:Richard Jacobsen Date:October 6 2004 10:29pm
Subject:Re: COMPRESS engine
View as plain text  
Thanks,  I'll give it at try.


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
> 	dnelson@stripped

"a professional is simply one who gets paid for doing what an amateur does for
																	-- Ursula K. Le Guin
COMPRESS engineRichard Jacobsen6 Oct
  • Re: COMPRESS engineDan Nelson7 Oct
    • Re: COMPRESS engineRichard Jacobsen7 Oct