Re: CPU usage

> Recently another group joined us on our development platform and > brought with them an Ingres engine. Performance on the box > immediately degraded. Just now I looked out there and discovered the > Ingres engine had been up for 36 days - in that time it had racked up > 1448:40 of cpu time! Comparatively our FOUR Online engines have been > up for 115 days and have racked up a total of :58 - now I don't know > what they are doing up there but this seems like quite a disparity. Much of the real work done by OnLine is done by the sqlturbo processes. They do the parsing, optimizing, disk reads and writes. The Tbinit processes simply coordinate this effort among all the other sqlturbo's so that no two processes duplicate work. Since I don't understand the Ingres engine structure, I can't comment if its 1448 minutes of cpu time reflects a lot or a little. Perhaps that (those) engine process(es) do all the work. -- Take Care -- Eric eric@carsinfo.com #include <std/disclaimer.h> ----------------------------------------------------------------------------- "It's Fabulous! We haven't seen anything like it in the last half an hour!" -- Macy's