Re: Locking problem in INFORMIX ONLINE 7.20. UC2 -Reply

Art S. Kagel wrote: > > Thuc Nguyen wrote: > > > > database and build new schema on Online 7.20 in a few days. > > > > Since I upgraded to Online 7.20 from 5.03, Do I need to create the > tables > > with extent size next size in order to keep less than 8 extents? > Does > > Online 7.20 handle it automatically? On 5.03, I created each table > with > > extent size next size in the past. > > You know, that warning about >8 extents is only an informational > message > and 8 is not a magic number. The engineers wanted to warn you about > tables becoming fragmented and had to pick a threshhold at which to > begin warnings. It used to be a magic number up to version 5.x, because the first 8 extents were tracked in shared memory. In version 6.x onwards the extents are tracked in shared memory dynamically. So the number wasn't picked at random, and is still probably a good number to aim at. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+