Re: Informix OnLine and Striping

In article <2t0e8a$j52@goshen.connected.com>, jvemo@goshen.connected.com (Jon Vemo) says: > > >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 are using striping on a large Informix database on a Pyramid. We saw a significant performance gain when we striped one dbspace. We had a 1GB dbspace that was our most active chunk by an order of magnitude (as measured by tbstat -D). We got a gain from striping that dbspace across parts of 4 disks. We used the Pyramid virtual disk driver to do this. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~ Jim Burks jburks@promus.com ~ ~ Database Administrator / Systems Engineer ~ ~ The Promus Companies, Inc. Memphis, TN USA ~ ~ http://stargate.promus.com/public/jbb.html ~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~