Subject Re: [firebird-support] Re: split or not split a table with long rows ?
Author Dmitry Kuzmenko
Hello, nathanelrick!

Thursday, March 22, 2012, 12:05:10 AM, you wrote:

n> by your message i understand you agree that it's a good thing to consolidate the table ?
>> Why not use a 16K page?
n> i need first to do test ... 16k pages use Twice more memory, and

Memory is cheap, just buy it.
About splitting table I have an opinion:
if some rows are being accessed more than other, than split table.
This will
- make row size less for most reading rows
- make less pages for most reading data

This can speedup some queries a lot. Had several cases
with this, did split, got huge performance increase.
But, this depends on data structure, etc.

Dmitry Kuzmenko,