>Suggestions 1-3 are mostly used in code.
>It is not possible to optimize code to increase speed significantly: The problem is that there are simply too many data which must be read to produce reports.

Since you are using the SYS(3050) functions, I assume do you have the source code. Why do you say "it is not possible to optimize code"?

>
>>4. Use SYS(3050) to define foreground and back ground memory. VFP doesn't do a good job of determining how much "actual" memory it has available to it and often requests more than the system has. When this happens it leads to disk caching and excessive thrashing of the HDD. Setting the values to lower numbers like 2**22 (4 Mb) or lower can actually speed things up.
>
>I have lines
>
>SYS(3050,1, 8000000)
>SYS(3050,2, 5000000)
>
>in my application. What's wrong with this ?

You have to try different settings to see which yields better performance. If I recall correctly, there was an article on the FoxPro Advisor a while back that determined that 4Mb foreground and 2Mb background of memory were pretty much optimal settings (for VFP6).
>
>>5. Look at using the HAVING clause which does post-query filtering and can greatly speed things up by performing a filter on a relatively small result set.
>>
>>6. Ensure that the TMPFILES=path in the CONFIG.FPW file points to a server local HDD folder.
>
>I don't use ANY TMPFILES path in confif.fpw file. In this case, VFP uses
>local temporary directory always.
>Why I need to use TMPFILES ?

You don't "need" it per se. It's just to ensure that temp files are kept local. I have seen some people that had an application on a local maching with data on one server and their temp files routed back to the server resulting in a tremendous load on the network and vastly degraded response times.

On another note, the use of switching hubs vs standard hubs and segmenting the network into multiple planes will make a huge difference in network throughput. Have you conisdered using a gigabit connection (or two) from your server to your network backbone? The costs of doing so has decreased significantly.
>
>
>>>I have compaq double processor Windows 2000 server with 700 MB RAM (400 MB used
>>>actually, remaining seems to be free).
>>>
>>>I have 15 W2K terminal server users and
>>>20 100 MB LAN users
>>>all they are running single VFP 7 application
>>>This application uses dbf files directly in server hard disk.
>>>
>>>However, the perfomance for large queries is somewhat slow.
>>>
>>>How to increase perfomance ?
>>>
>>>Is it reasonable to upgrade to W2K Advanced server and use more processors.
>>>
>>>W2K server allows only 2 processors, W2K advanced allows up to 8 processors.