Re: [Q] fragmentation and rowids

Posted in 1997

"David Coburn/ISG/WVUS/WorldVision@WVUS" — 13 Mar 1997 16:53:22 -0500 — source: Informix-list mailing list archive (1991-1998)

Well, Richard, I would be happy to tell you that you're wrong, except that you aren't. This is the way things work starting with that release of OnLine. This was documented some time ago as being a natural result of fragmentation. Besides, rowids are hardly relational; if you are using them, you have been running a risk for some time now of a broken application. David >So what you're saying is that an application using ISQL forms will >work perfectly OK following an upgrade (as it did at my last place >of employment when we upgraded from 5.0.3 to 7.13/ISQL 4 to 6), >but if 'the powers that be' decided to fragment tables, EVERY table would have to be rebuilt with rowids >before ANY ISQL form would work. > >Jeez! > >(This would be an issue - c.50 databases of varying sizes, all using PERFORM as the front end). > >Please tell me I'm wrong!!! > >Richard.