I am not aware f any cache files that studio would use, so I think
you would need to check a few things on your slow machine. When the
script is running, look at the memory in the taskbar, is it flipping
out and using swap space? I suspect it is and hence the slow down. To
help improve this you can make sure you don't have unwanted programs
running, check taskbar and see what is using memory and stop them if
needed. Another thing to do would be to do a checkdisk and a defrag.
If you have a really defragmented system then when the data is being
written to the disk it will take longer.

So in general my thoughts would be there is something making your
machine slower or using most of the memory up ?

Oh and i agree with kylesimpson 4.5 should be faster.


--- In NADUG@yahoogroups.com, "kylefsimpson" <kyle.simpson@...> wrote:
>
> Hi,
>
> We have experienced the same results with mrStudio 4.0 as well.
> Sometimes it results in tables missing (empty worksheets), other
> times the unknown aggregator error.
>
> Our 'fix' has always been to shut down mrStudio and re-run.
>
> I haven't tested it in any more recent releases, but I'd expect
that
> they've improved the export.
>
> --- In NADUG@yahoogroups.com, "dancing_lake" <chewygold@> wrote:
> >
> >
> > Hi,
> >
> >
> >
> > I have found when using the TOM module of MrStudio 4.0, the
export
> to
> > excel process can be very slow. When there are many tables, or
> looped
> > tables i often get an unknown excel aggregator error when the
> export
> > fails. the odd thing is that i have been using MrStudio TOM and
> DMOM 4.0
> > for about a year on this machine. I can go to another machine and
> > export the same Excel file in less than 1/2 the time without
> issue. My
> > computer has twice the memory and processing speed of this
computer
> >
> > i am beginnig to think that MrStudio TOM has a hidden cache
memory
> > somewhere on my computer that is almost full to capacity. And the
> > difference between the 2 computers is that the second, smaller
> computer
> > does not have as large of an mrstudio memory cache because it has
> not
> > been in an MrStudio TOM production mode for as long.....
> >
> > Has anyone else had this problem? and if so, have you found a
> hidden
> > cache and found a way to remove it?
> >
>