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, www.ib-aid.com