Re: Fragments

In one sense - yes. But Online also uses fragmentation for process spawning. So even if you have two fragments on the same drive it will help because the engine will spawn two scan threads, one per fragment instead of just one. Fragmentation is a good thing - just be sure you use a sensible fragmentation scheme that helps - keep your fragmentation clause simple. cheers j. Albert Wisse <wissea@cayennesoft.com> on 05/29/98 06:25:56 AM Please respond to Albert Wisse <wissea@cayennesoft.com> To: informix-list@iiug.org cc: (bcc: Jack Parker/Boston50/Epsilon) Subject: Fragments Hello, I want to verify if I am right: I think using fragments make sense in the following case: My hardware is: Sun Enterprise server with 4 * 250 MHZ CPU's (NUMCPUVPS = 3) Internal memory 1280MB Sparc Enterprise Network Array (SENA) disk-subsystem The disksubsystem has 2 times five disk in use for Informix. I use RAID level 0+1, five disks in a strip set with a strip size 16K. The disksubsystem is connected by two channels to the server and load determines which cannel is used. If I am right then I can see the disksubsystem as at least two big disks, so fragmenting my tables make sense. In general with stripped and/or mirrored disks can you say then that fragmenting will boost performance. __ _/ __ Albert Wisse \\ \\\\// / Cayenne Software Customer Services \\ \\/ / Olof Palmestraat 24 wissea@cayennesoft.nl C A \\ / E N N E 2600 GB Delft (+31) 15 21 519 10/19 / / the Netherlands (+31) 15 212 0267 (Fax) /_/ http://www.cayennesoft.com Cayenne Software is a Bachman and Cadre company