Hi Chris,
FWIW I wanted to comment on the server hardware you are talking about.

Visual FoxPro is not going to see much benefit from added ram on the server. If this is a terminal server sure the ram will have some benefits. I'm not too sure how terminal server handles multiple processors you might want to check on that one. Also multi processors is of no benefit to VFP as well. Either on workstation or server. NT/XP may or may not run different processes on other processors but I dont think the benefit is as great as people may think.

Now onto the # of users: Back in the FoxPro days we ran 150+ users on a single server and 386 (yes 386) diskless workstations. This system had a large number of inserts (for those days at least) Could we have gone to 300+ people; I think so.

However, depending on the retail store you are working in I would imagine that 24/7 operations may be a concern. A good set of questions to ask are:

1. How do I back that data up when the system is in full operation.
2. What happens when the system goes from 300 to 600 users (Not an unlikely situation if you get to 300)
3. What is the cost of down time for reindexing or foxpro file corruption ?
4. What happens when the retailer wants to create a data warehouse ?
5. What happens when one of your compeitors uses SQL Server or Oracle and bad mouths FoxPro to the client (this has happend to 2 of my clients in the past few months)
6. Will a retailer with 300+ workstations overrrun the foxpro file limitations? Retailers have some of the largest databases in the world and their data needs are enormous (which I'm sure you already know)


FWIW we have a VFP/SQL Server installation that has 800+ workstations and 600GB of data. We have one table that has 800,000,000 rows in it. And a system that does tons of inserts/queries/updated a second.


thanks
Rodman