Re: oncheck performance issuest (fwd)

Seems as if I got the right tape from Informix (sorry guys). Unless you supply me with more info. Size of DB etc..... I keep my tbcheck -pe reports which are performed in my cron like: date;tbcheck -pe;date The difference on both system is about 30 secs..... ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR kendric@gwysmtp.jcdc.doleta.gov OR cherylk@spamis.jcdc.doleta.gov DTSI, Inc. Voice: 1-800-598-5008 Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On Fri, 19 Apr 1996, Informix Sysadmin wrote: } > I run a pe every morning on my 7.10(now 7.12 as of yesterday) system } > that is covering almost 3GB. Now mind you it does not have that } > much data (if it has 1GB (being in development, I would be surprised)). } > } > Yet it only take me 30 sec to run a tbcheck -pe. I think you may have something } > wrong. You might want to check this out. Now for the tbcheck -cI and -cD } > I haven't ran, but I am going to start. If you are interested in my times } > let me know. } } It only USED to take milliseconds. It now takes minutes :( } } > Even on my 10GB full of data on Informix 5.02 it does not take 5 minutes } > to do a tbcheck -pe. I just ran one with 64 active process and it took 30 } > seconds. Something is up with your system (hum!!!) } } Our 5.x was LIGHTNING fast....7.x FAR from it :( } } B. } } ------------------------------------------------------------------------- } |Brian P. Hampson Internet : brian@asl-labs.bc.ca | } |System Administrator, Air(2m/70cm): VE7NNW | } |Analytical Service Labs Fidonet : Brian Hampson 1:153/733| } |Vancouver, BC | } |+604-253-4188 | } | Specialists in Environmental Chemistry | } | | } ------------------http://www.asl-labs.bc.ca/----------------------------- } } }