>>>>What is the function to check to see of the PATH is
>>>>really out there?
>>>Use something like
>>>
>>>is_dir=DIRECTORY('C:\TEMP')
>>>
>>>Re: Tempfiles:
>>>VFP uses the default temp file area used by windows, normally you should have a directory like c:\temp set up and a statement in your autoexec.bat (I believe this is where windows is getting it from) like
>>>
>>>SET TEMP=C:\TEMP
>>>
>>>
>>>Everyone should have a temp file on a Local hard drive to minimize network traffic
>>>
>>>Remember that the config.fpw is a pre-load file and the tmpfiles setting will override the default and cannot be changed once your program is running. So your testing for a temp directory from your program will not do anything for you. It needs to be set up beforehand.
>>
>>thanks again Larry.... I have an EXE on my local harddrive and
>>a DATABASE on a network drive. I am putting in TMPFFLES = C:\MYDIR
>>in the confir.fpw so the data will return faster. Other than PHDBase, do you know of some other ways to speed thing up?
>If you are running Novell (I'm not sure but this may be applicable to other networks) you can adjust your network packet size. I'm not a hardware/network type but I know this can be adjusted say from 512 to 2048 bytes. I think it's call frame-buffer. A definite consideration is to increase RAM on the server and/or use a caching controller. Most likely 90-95% of the speed difference is due to network efficiency or lack thereof. It's just a matter of $ in the long run.

Hi Larry... thanks for your answer.. I was hoping you would say that I
needed to add an index to my TABLES or SET SOMTHING ON for more SPEED.
I can not believe I have to deal with network efficiency. I guess I need to get a list of THINGS TO DO FOR FASTER ACCESS off the internet.
thanks again...