Re: OnLine 5.0 ESQL/C Query timing problems

In article <403mhv$9ej@newsbf02.news.aol.com>, plkapp@aol.com says... > >Version 5.01 of Online has a bug in Update Statistics. I >have found my copy of the proposed work-around from Informix >Tech Support. (Bug #14829 - Scheduled Fix 5.02.UC1) This bug >affects tables that undergo bulk inserts and bulk deletes to >get negative values in np_used statistics (in systables), Whatever the fix is scheduled for, the bug still appears to exist in 5.03.UC1. Script: select npused from systables where tabname="glatemp_rec"; update statistics for table glatemp_rec; select npused from systables where tabname="glatemp_rec"; Output: npused -27 1 row(s) retrieved. Statistics updated. npused -27 1 row(s) retrieved. But thanks for the workaround. One comment: LET numpgs = numrows / (2020/(rowsz+4)); I think the 2020 given here should be based on the system's page size. -- William Harris william@carsinfo.com CARS Information Systems http://www.carsinfo.com/~william/ 4000 Executive Park Drive Cincinnati, OH (USA) 45241