Informix OnLine and Striping

} } } In reviewing system performance, we found no significant bottlenecks. } However, a consultant has suggested we stripe our raw data. I am not } convinced that a significant performance improvement may be gained, } as the database is quite large (52GB) and VERY dynamic, with rapid } growth. (most frequently accessed data, towards the end). } } We currently run on a Sequent /700, OnLine v. 5.0, but anticipate } migrating to v.6 and v.7 within 12-14 months. Once on v.7, we plan } to use fragmentation, hence we would be row or key level striping. } } The question of the day is....Is anyone using striping with Informix, } what are the pro's and con's, and would they do it again? } Couple of years back I tried this on a DataGeneral box. It actually made things slower. Your mileage WILL vary. cheers j. _____________________________________________________________________________ Jack Parker | Hewlett Packard, BSMC Boise, Idaho, USA| If you put all of the lawyers in jparker@hpbs3645.boi.hp.com | this country end to end, (208) 396-5388 (W) (208) 384-1623 (H) | it would be a good thing. _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________