Complex Table Downloads in Syclo IM for very large data volumes

Hi,

Would appreciate any guidelines around managing complex table downloads (in Syclo IM) for very large data volumes. We've implemented filtering - to the best extent possible - and am aware of the standard recos around reducing indexes / index levels. We're dealing with HUGE volumes (e.g. No. of Materials from 500,000 to 1,000,000, depending on the filtering strategy chosen (yes, not a typo!)).

None of the transmits, beyond a certain stage (300,000 materials or so) are going through - just hanging and eventually timing out (time-out has been progressively increased to very high values).

Thanks for your help.

Prashant