Re: Informix OnLine and Striping

jvemo@goshen.connected.com (Jon Vemo) writes: >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). The purpose of striping IS to GAIN performance...... >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? You do not say if you have Sequent's Volume Manager (SVM)...It was created for the purpose of providing logical volumes, striping, and mirroring..... Utilizing the "built-in" features of the database vendor's db usually does NOT improve performance (much)....SVM enables you to localize "hot-spots" and handle them ON-LINE!....I would suggest you talk w/the Sequent hot-line and/or you local rep. BEFORE you proceed..... >Any replies would be very appreciated. >Thanks >Jon >===================================================================== >Jon C. Vemo Internet: jvemo@connected.com >Bothell, WA USA >===================================================================== -- --/nl ..... rjledger@world.std.com