64k blocks vs 4k blocks
From: Michael Joseph <qmick_at_nyc.pipeline.com>
Date: 1995/08/29
Message-ID: <420fsp$1v2_at_pipe3.nyc.pipeline.com>#1/1
Date: 1995/08/29
Message-ID: <420fsp$1v2_at_pipe3.nyc.pipeline.com>#1/1
We are experimenting with moving our (almost) read-only data base from a 4K block size to a 64K block size.
Tests have shown that on large tables there is a slight gain here but when a large table on a 64k volume is joined to a 4k block smaller table there is a penalty approaching 100% against performance.
Any other feedback on this would be useful.
MJ Received on Tue Aug 29 1995 - 00:00:00 CEST