Hi, the Database indexes are not optimal for the ObjectCustomFieldValues table. Sadly I didn't had time to dig deeper into this. But maybe you have time and an new index will help you.
There is already an ticket open for this: http://issues.bestpractical.com/Ticket/Display.html?id=16898 Chris -- RT Training in Seattle, June 19-20: http://bestpractical.com/training
