If you have a wide table and want to optimize performance you would do
better to increase the page size.
JS
Jay Sprenkle wrote:
On 5/2/06, Felix Schwarz <[EMAIL PROTECTED]> wrote:
Hi,
Morning!
"Put small and frequently used columns early in the table to minimize
the need to follow the overflow chain."
Now, that's interesting! And I'm wondering whether there is a big
performance hit for a simple
SELECT binarydata FROM entries WHERE somehash = 27817298;
That is interesting!
I guess this would only apply if the indexed columns in a single row are
larger than the page size of the btree table.
I don't know for sure, but I would bet the overhead of creating an index
to join the two tables would be much higher than the overhead of loading
an overflow page.
It's probably worth looking into
