Foglight Experience Monitor (FxM) is slow to respond when navigating between pages/reports. Sluggish performance on web console UI.
Defect FXM-206: When indexes exceed some size threshold, MySQL switches to using a secondary (much slower) index key for this database query. The fix is to force the code to always use the primary key for the query (that had always been the intention).
Fixed in the January 2012 patch/hotfix. This will be available from Supportlink in early Feb.2012.