Oninit cdi / Archive
Talk to an expert →

Fragmentation opinion wanted.

Posted in 2000

Topics: Storage & Space Management, Platform-Specific Issues, Versions, Editions & End-of-Life

Paul Howard — — source: Informix-list mailing list archive (1991-1998)

We have IDS 7.31 and AIX 4.3 I am being told by my software vendor that I should not fragment tables using Informix fragmentation. They say that it would be better for me to optimize my system by spanning dbspaces across multiple disks and letting the hardware fragment the table. This is contrary to my experince and schooling. Can anyone tell me how much merit this statement of my software vendor has?

↪ replying to Paul Howard
mars1972@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

In article <8a8pop$s8m$1@news.xmission.com>, Paul Howard <paulhoward@home.com> wrote: > > We have IDS 7.31 and AIX 4.3 > > I am being told by my software vendor that I should not fragment tables using > Informix > fragmentation. They say that it would be better for me to optimize my system by > spanning dbspaces across multiple disks and letting the hardware fragment the > table. > > This is contrary to my experince and schooling. Can anyone tell me how much merit > this > statement of my software vendor has? > > I obviously don't know anything about your case specifically, but by using the hardware fragmentation option, Informix will not know that the table is fragmented, and will not give you multiple threads for scanning each logical fragment. Also, it will not be able to do fragment elimination. I'd have to say that the vendor is blowing smoke. Would he happen to be trying to sell you the hardware? -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to Paul Howard
Watawinona — — source: Informix-list mailing list archive (1991-1998)

>Subject: Fragmentation opinion wanted. >From: Paul Howard paulhoward@home.com >Date: 09.03.00 19:03 W. Europe Standard Time >Message-id: <8a8pop$s8m$1@news.xmission.com> > > >We have IDS 7.31 and AIX 4.3 > >I am being told by my software vendor that I should not fragment tables using >Informix >fragmentation. They say that it would be better for me to optimize my system >by >spanning dbspaces across multiple disks and letting the hardware fragment the >table. > >This is contrary to my experince and schooling. Can anyone tell me how much >merit >this >statement of my software vendor has? > Depends on the type of fragmentation. I assume you mean expression based fragmentation. If so, no, the Informix fragmentation is definitely better. Nona

Glossary