Hi,
>We have an application that runs using VFP7 with a foxpro database. The application and data is stored locally and is used by about 80 users, all working locally. All the routines access the tables directly and don't use remote views.
>
>We are considering extending the application to be used by one of our branches in South Africa and this will eventually add another 120-200 users to the system.
>
>We are looking at using terminal services to allow access to the system but we're worried about the response times with so many users being added to the system.
>
>Has anyone any idea of:
>- if this will be feasible
Take a look at
http://download.microsoft.com/download/5/8/c/58ccf087-33c1-41b2-bb74-fe20be37fde6/TermServScaling.doc.
MS seem to have no problems scaling to that number of users given a reasonably specced server.
>- what the effect will be of 200+ users accessing a foxpro database
I suppose it depends on the type of data manipulation the users are performing. If it's mainly just adding/updating/deleting records it shouldn't be a problem.
>- the implications of all tables being accessed/updated directly rather than using views/updatable views
>- is there anything we can use to predict the effect on response time
Maybe you could (to a certain extent) test the TS performance by moving some of your existing UK users over to Terminal Services. Of course the bandwidth available between S.A. and here is an additional factor...
>I've also heard citrix mentioned, is this advisable or a must for this number of users?
TBH, I've used neither TS or Citrix enough to venture an opinion. Citrix seems to be generally perceived as more robust. But also more expensive :-{
Probably someone with more experience will chip in....
HTH,
Viv