Slow partition process when fact table has more than 1'000.000 records

[DiegoErnesto]

Hi;

Please; when I have the fact table less than 1'000.000 records the process take time 6 min. but when the fact table pass this amount the process take time 45 min.

Analysis services 2000, enterprise edition, SP3A
Windows 2003

Before; I didn't have problem in windows 2000.

What happend?

Thanks and Regards.

 

[johnherman]

This sounds like one I would report to M$

-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright

 

[MDXer]

what aggregate types do the measures in the cube have? Any distinct count measures?

Shoot Me! Shoot Me NOW!!!
- Daffy Duck