Its in this thread, which you have kindly replied to. I'm busy doing some tests before replying further. I keep uncovering more-and-more disastrous performance and not entirely sure which way to jump :
http://forums.sqlteam.com/t/autonomy-imanage-sql-performance/2946