StevenD ...

With the 400+ attributes per product this will take some time to load ...

In the next couple of upcoming releases this should help you quite a bit ...

I would be interested in a copy of your database to work on further optimizations as your site definitely pushes the limits and would be of great help in testing the new versions before release ...

If that works for you ... please drop me a PM ... thanks!