Hi Eric,

>I have some vfp8 applications that are getting slow when adding users (uses VFP database on a WinServer).

>I wonder what is the best situation for a 10-20 users setup:
>
>- Run the application as is on terminal service (MS or Citrix?)
>- Modify the application to run as client-server (with MS-SQL or MySQL?)

IMO, a TS or citrix is better on average. For applications that handle lots of data performance is significantly slower when accessing through a WAN. a TS/CITRIX solution ensures that the network is not a bottlenext for any data operation. Only screen updates might be slower, but acceptable in most circumstances.

Typically my application generate/uses a lot of files not stored in the database. For example
- Word mailmerge documents (For generating letters)
- End users word documents (Letters)
- Excel documents.
- Graphics
- Crystal Reports

Even if you build a CS version of your application lots of data still have to travel the network. For example, if you want to generate a report based on lots of data, a Citrix solution is better.

In the above I'm asuming a WAN network. If a LAN is use the difference is not that significant. Installing a SQL Server, migth be a whole lot cheaper than a TS/CITRIX solution then.

Walter,