Re: Single CPU Performance Problems?
Posted in 1999
"Gregory P. Schin" wrote:
>
> Thank you all for the responses. We have made some changes to the onconfig and
> had an improvement to around 18 rows a second. But - after about 1 hour it just
> seems to hang. I will post below the new onconfig, the onstat output when it is
> running good and then the onconfig output when it is hung. While it is hung the
> cpu is pegged, the hard drives are not doing anything and that lasts for about
> 1/2 hour. After about 1/2 hour it goes back to processing the rows at about 18
> rows a second.
>
> I am going to keep trying different things to improve the performance. Also, I
> am trying to figure out if the database is causing the 1/2 hr delays.
I can't remember the start of this thread. But is it possible this delay
is a checkpoint?
Cheers,
--
Mark.
+----------------------------------------------------------+-----------+
| Mark D. Stock http://www.informix.com |//////// /|
| mailto:mdstock@mydas.freeserve.co.uk |///// / //|
| http://www.iiug.org +-----------------------------------+//// / ///|
| |What year 2000 bug? year 2000 bug? |/// / ////|
| |year 2000 bug? year 2000 bug? year |// / /////|
| |2000 bug? year 2000 bug? year 1900 |/ ////////|
+----------------------+-----------------------------------+-----------+