Re: Informix SE 5 and Large Database

Jay Falck wrote > >I am running Informix SE 5 on an ATT 3425 tower with 512M and 25gb of >raid. I am experiencing frequent system lockups when adding rows to >some tables. It appears the UFS files system is having to make copies >of data when it expands and this takes a long time (some times as much >as 3 minutes). I have considered artificially growing the tables with >invalid data and then deleting the added rows during off shift to >allow the movement to occur without effecting the system during prime >time. Is this a viable idea. Yes, your tables will be less fragmented - faster access. SE will faster insert records because disk space is already allocated. >I have switched from RAID level 5 to RAID level 4. Why? RAID5 should be faster, reliability is same. -- Chris Drauch ...................................................................... . c/o DRAUCH Ges.m.b.H. Tel. 43/ 3135/46387-0 . . Gewerbestrasse 5 Fax 43/ 3135/4638728 . . A-8071 Hausmannstaetten EMail cdr@xteam.co.at . ......................................................................