Re: 2 Informix SE problems

In <58n37j$gf9@nntp.idgonline.no> Nils.Myklebust@idg.no (Nils Myklebust) writes: >On a customers SE engine (5.01.UD2) it uses about 1/10 second to count >to 12914. This speed has allways been true for all my counts with no >where clause on SE and OnLine, whatever the number of rows. >I allways believed Informix stored this count somwhere with the table >(in the index file?) with SE. It shure isn't in systables as this is >only updated when update stistics is run. This seems very slow to me. I've just run a count on two tables on a customer's site (during normal workload). The results table a 294444 rows 0.09 secs table b 372833 rows 0.10 secs and this was using CURRENT to display times, so the processing overhead of doing the LET/DISPLAY must be taken out. Nowhere near the original posters 6mil. rows I know, but could still be indicative unless the SE engine experiences some sort of logarithmic response curve as it gets up to larger table sizes. OK, maybe this info was already in OpSys buffers, but my experience would suggest these speeds to be real in any case. SE 7.12, SCO 5.0.2, RDS 6.04, Pentium Pro 200Mhz. Bryan Tonnet batonnet@zeta.org.au