Search the web
Sign In
New User? Sign Up
NADUG · North American Dimensions User Group
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Message search is now enhanced, find messages faster. Take it for a spin.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
MrStudio Cache memory   Message List  
Reply | Forward Message #86 of 164 |

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?









Sat Apr 12, 2008 4:07 pm

dancing_lake
Offline Offline
Send Email Send Email

Forward
Message #86 of 164 |
Expand Messages Author Sort by Date

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...
dancing_lake
Offline Send Email
Apr 14, 2008
6:34 pm

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...
kylefsimpson
Offline Send Email
Apr 14, 2008
9:06 pm

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...
dporton
Offline Send Email
Apr 14, 2008
9:29 pm

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...
dancing_lake
Offline Send Email
Apr 15, 2008
11:20 am

This has got me interested now... You are correct ... deleting the files in ... C:\Documents and Settings\[Username]\Application Data\SPSS\mrStudio\4.0.0.0 ...
dporton
Offline Send Email
Apr 15, 2008
10:17 pm

Yes - there is anti-virus software that runs in the background (corporate standard). temp files are removed regularly, and i have defragged the disk recently...
dancing_lake
Offline Send Email
Apr 16, 2008
11:43 am

This is interesting, I have done some investigating and you are very correct with your thoughts. It does seem as if the clipboard is used. which is news to me...
dporton
Offline Send Email
Apr 17, 2008
12:59 am

I will run some tests and set the annotations to false and I'll let you know what happens....
dancing_lake
Offline Send Email
Apr 17, 2008
11:22 am

how did you go with this ? did it reslove your issues ?...
dporton
Offline Send Email
May 19, 2008
9:21 am

... Hi, sorry it took so long... been busy anyway. not using the annotations helps the export speed, but the clipboard still ties up during the export process...
dancing_lake
Offline Send Email
Jun 2, 2008
10:30 pm

Hey thanks for commenting. i have found that empty worksheets can be a problem, so i usually do a quick for each loop after populating to remove any tables...
dancing_lake
Offline Send Email
Apr 15, 2008
11:33 am

How do you do it? ________________________________ From: NADUG@yahoogroups.com [mailto:NADUG@yahoogroups.com] On Behalf Of dancing_lake Sent: marted́ 15...
pietro.tranquillino@...
tranquillino77
Offline Send Email
Apr 15, 2008
11:35 am

hi, I just create a variable at the top, to include all tables in and then check right after populating to see if Xvariable = 0 then remove the table. ... ...
dancing_lake
Offline Send Email
Apr 15, 2008
11:46 am
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help