Re: 2 Informix SE problems

Bryan Tonnet wrote: > > 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. My point exactly. You are surely not suggesting that it has a linear one? Cheers, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+