Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Question of Database Development w/ Server
Message
 
To
13/11/2003 02:22:33
N. Lea
Nic Cross Enterprises
Valencia, California, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00846029
Message ID:
00849488
Views:
33
I've seen instances where there are 100+ users on the same server (it has to be a very fast and beefy server). You need to just keep in mind that each user gets a virtual session of Windows - so figure 70-100mb RAM for each user. You would also need to ensure that long processes (big reports, or batch processes) are either 1) run at night or during some non-peak time, or 2) done in such a way to as to limit the necessary processing needed by the local machine. Even with a very fast multi-processor machine, VFP will try to use everything it can when you ask it to run a report that takes hours to complete - and this might make the other sessions slow down (depends on the power of the server).

If all you have, however is 10 users accessing the machine - you should be fine.

Make sure each user is running a separate copy of the program - using a launcher, make the user a local temporary directory, and copy the executable files into this directory for the user to run. One thing that you have to think of is - we always write programs under the assumption that they will be run seperately on different machines accessing data on another machine. In this case, the program is running on the same computer and being accessed by different people simultaneously. It is always a good idea in general to run a separate copy of the program, but even more so in this case.

-w-



>Hi thank you for answering my question. Do you know how many people can access through Terminal Services on a Windows 2000 Server that is connected to a T-1 line. I just want to make sure that if I have one Foxpro application that it will be fine if 10 people are using it at the same time.
>
>Thanks.
>
>>Have you thought of implementing a Terminal Server solution? With this you could allow all the people you need to have access to the program, and will keep from having to update multiple copies on the desktops.
>>
>>
>>
>>>This may be a stupid question, but I have to ask it anyways for a solution. I currently have created a program, which the person whom wanted it created, that was intended for in-house with just a few people. Now, my client wants a server and the database placed on the server, and the application to be used and accessed thru VPN. Right now, the main function of the database asks for a filter to be called from one table and then those filtered records are set relation to another table. I know that I could actually have FP8 copy the filtered information into a temp table. However, when I go to save it would that be too much of a hassle. At the same rate, while the client's employees will have their own version of the program on their own desktops, the client wants to have a read-only version of the same program placed on his website so that the customers can also see that information. I wish to find a way to make it readily available if people on the web and people on VPN were able to
>>>look at the same data? Does that make sense?? Thanks for any help!!
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown
Previous
Reply
Map
View

Click here to load this message in the networking platform