Statistics timing out (won't load) 1.6

[OllyL]

Hi There,

 

We've just upgraded our shop to 1.6 and we're having problems with statistics. When you click the link on admin it just sits forever and won't load the page. I'm not sure if it's a particular query in there (cross join or something) but it means the page just times out before we can see anything.

 

I download the database optimizer module to clean up some other tables in case this was the problem (it cleaned about 20 million connections) but it doesn't seem to have helped.

 

Anyone got any ideas? Does anyone know the default report which is loaded when you first click stats?

 

Thanks,

 

Olly