Hi Jim,
Nope, TotalCommander and all operations were done on the same
SQL/Processing machine accessing files across the network on our
fileserver.
This morning, I created a temprds folder on the fileserver and moved
the needed files to it, then changed the prefs to use that folder for
rowork. Ran in under two minutes.
When I came on to check my mail I was already copying the files from
the fileserver to my local workstation to test things out locally and
see where the bottleneck might be.
Thanks for the suggestions. I'll be back and probably post the
relevant code if I can't find an answer.
On 6/30/05, Jim Payne <info at spiffycharts dot com> wrote:
> >> Yes! It appears that it took almost 3.5 hours to parse through 4,900
> >> some files and move the matching ones to a different folder.
> >
> >
> > Something sounds wrong here.
>
> ....Snip
>
> It sure does. My guess from way outside is that you are looking at
> network delays, not problems with your code.
> Question.. Does "TotalCommander" run on the same PC that holds ROWORK?
> If so, that would explain the reason for its realative speed.
>
> Wild hair suggestions:
> 1) Depending on file size, maybe copy the entire set of files to your
> PC, then do your comparisons. The comparisons with file name should
> really take only 5 seconds or so. (I have a routine that works through
> 4500 files in about that time.)
>
> 2) Put your program on the Machine that holds ROWORK. Have a timer
> which runs the code hourly.
>
> anyway the suggestions are free.
>
> Regards,
> Jim Payne
>
>
>
>
> _______________________________________________
> Unsubscribe or switch delivery mode:
> <http://www.realsoftware.com/support/listmanager/>
>
> Search the archives of this list here:
> <http://support.realsoftware.com/listarchives/lists.html>
>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|