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
