>We have a FPW26 app that has to "extract" data from a dbf and dump it in a temp file for printing. Since we extract various data from only selected fields in each record we use a counter (FOR/NEXT) using the incremented counter to identify the field name (class1,class2, class 3 etc up to 12)
>This works absolutely perfectly on the Server, take 3 or 4 seconds to process. ( Admittedly this is a 350Mhz with 128 meg RAM ) However on a workstation (166 with 64 Meg RAM) it takes over 2 minutes. Obviously there is a great deal of network traffic (hub is flashing wildly)
>We've tried setting TMPFILES/PROGFILES/SORTFILES ETC = c:\something or other in CONFIG.FPW, doesn't help. In any case we're not sure where that Config.FPW should be or for that matter what it should point to.
>
>It seems the time differential is too great for it just to be processor speed.
>
>Any ideas ??

Hi Richard,

The TMPFILES, etc. should point to a directory on the C: drive. However, I'd make sure that the specified CONFIG.FPW file was the one actually in use. If, for example, the DOS environment variable FOXPROWCFG is pointing to a different configuration file (other than in the default directory), and you're assuming that the one in the default directory is being used, any changes in that (in the default directory) file will have no effect.