IDS 7.30: a table with 150 extents

Hi folks, I have this table: 4 million rows (at one point it had 17 mill), 700Mb and 151 (!) extents! It's not fragmented. I wasn't the one who designed it that way so please don't nail me for that. My question is: how come we don't see any performance problems? Is there optimal extents number for IDS 7.30 (like 8 for online 5)? Or is it just powerful box? Hardware: HP NetServer LH4, 4x PII Xeon 400Mhz, 2Gb RAM, 6 logical HDD's (12 physical, RAID 10) for dbspaces OS: SCO OS 5.0.5 Any ideas will be greately appreciated. Thanx! Alex. -- Before the accident, I could not even spell UNIX Sent via Deja.com http://www.deja.com/ Before you buy.

Alex Barilo wrote: > Hi folks, > > I have this table: 4 million rows (at one point it had 17 mill), 700Mb > and 151 (!) extents! It's not fragmented. I wasn't the one who designed > it that way so please don't nail me for that. > > My question is: how come we don't see any performance problems? Is there > optimal extents number for IDS 7.30 (like 8 for online 5)? Or is it just > powerful box? The main reason for the 8 rule in online 5 was that the extent table was fixed at 8 entries. For any table larger than 8 extents the partition page had to be scanned. In 7.x+ the extent table is dynamically sized so that all of the extent information is kept in memory. > > > Hardware: HP NetServer LH4, 4x PII Xeon 400Mhz, 2Gb RAM, 6 logical HDD's > (12 physical, RAID 10) for dbspaces > > OS: SCO OS 5.0.5 > > Any ideas will be greately appreciated. > > Thanx! > > Alex. > -- > Before the accident, I could not even spell UNIX > > Sent via Deja.com http://www.deja.com/ > Before you buy. -- Madison Pruet =========================================== Enterprise Replication Product Developement Dallas, Texas Informix Software ===========================================