Hi, and Thanks for your comments - i have checked my computer out but
the cpu usage doesn't go over 50% and the memory doesn't hit the max.
i have dual processors for 2.8 Ghz with 2.5 gb ram and am expecting
an upgrade soon. One thing i do notice is that having outlook open
often causes the unknown aggregator error in during an excel export.
if i have problems and shut outlook down i can run the same file
without issue. i suspect it has something to do with the ms clipboard
and hidden temp files, but as yet have not been able to find any
hidden files to remove.

i think my company is skipping 4.5 and will be loading 5.0 (currently
testing) or 5.5 on our machines. so i am also hoping that 5.0 or 5.5
improves this part of the TOM experience.


--- In NADUG@yahoogroups.com, "dporton" <DouglasPorton@...> wrote:
>
> 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?
> > >
> >
>