LMT advice

From: foolishHurts <silverback_at_photobooks.com>
Date: Thu, 25 Sep 2003 15:32:16 -0400
Message-ID: <ilf6nv0j5ik7rp3ambgana7opfs3825hbe@4ax.com>

We are looking at LMT (finally) and I find two options: Autoallocate and uniform.

I find with autoallocate, we are seeing truely huge amounts of extents (2000) of very small size (100 KB). While 100 KB seems reasonable for small tables, for large tables I would expect extent sizes in the MB range.

Question:
Which is better and why: Uniform (one large, one small) or Autoallocate (and ignore extents)?

Also, I can not find the old note where I stored the archive location for this newsgroup, so please post that address as well.

Thanks!

Evan

Currently on 8.1.7.4, heading for 9.x as fast as we can drag our vendors and customers. <GRIN> Received on Thu Sep 25 2003 - 14:32:16 CDT