HUD - Hero Update time/CPU

[ChicagoAl]

I'm trying to diagnose CPU/Performance problems, and it seems (from observation) that there seems to be something really intensive going on with the updating of the Hero stat in the HUD that is clogging the rest of my system (Mac Pro Quad Xeon 12gb RAM). My database is big but not unwieldy (<1 Million tournament hands) Here's what I observe:

On a single table, Refresh Rate set to 1:
Hand ends;
Log file: 2011/03/27 13:33:19.176: [B0185000][StatManager] Cache update times. Find: 0 ms; Pop: 318 ms; Gen: 153 ms; Exe: 109 ms; Com: 1 ms; Total: 581 ms
Log file: 2011/03/27 13:33:19.178: [B0185000][ImportAuto] Adding message: Cereus Network: Hand Imported (#627527430) from 41961676
HUD for Table Stats and for All Players except Hero update <1 second after hand ends;
Mucked cards display is <1 second after hand ends;
CPU % for PokerTracker 3 Process goes to 100% and hovers there for <> 25 seconds (observed in Activity Monitor)
When CPU Drops, Hero Stats are updated

On multiple tables, this <> 25 second delay compounds so that a backlog is created that often creates a several minute delay between hands ending and HUD stats being updated, affecting all tables and all players. One observation I have is that on a single table, the log file never shows more than 8 queries pending, but with only 6 tables going I often have <>50 queries pending and very long delays with the CPU pegged for the 55 minutes of active play between tournament breaks.

So finally to the question - how do I diagnose and reduce the Hero overhead so the rest of my system runs more smoothly?

[WhiteRider]

Hero stats don't use the cache, but since it's only retrieving stats from the current table that shouldn't matter.
One thing you can search for in the logs is the query "execution time". See if you have any really long queries - there shouldn't be much more than 3 figures (in milliseconds), although you'll probably have a few just over a second. If you have any that are taking multiple seconds that could slow things down.
If you want us to help you analyse please attach your log file to a Support ticket and include a link to this thread.

[ChicagoAl]

Thanks White. I just submitted ticket #107327.

[WhiteRider]

Thanks – we'll get back to you via your ticket.