>Ok, I understand that throughput can be a performance issue. I was wondering; if you have a VFP front-end and a VFP back-end is there a simultaneous use problem? If 5000 users all try to access the same table at the same time, who craps out? I would guess the server would die under the load and the front end (VFP) wouldn't know why.
You should post a message for Rick Strahl on
www.west-wind.com to see if he has experienced any upper limit on the number of connections to a table. One time when I posted that he had got 500,000+ hits on a database per day he corrected me and said that it peaked out at something over 700,000 hits per day (if I remember correctly). He might be able to shed some light on what is the limiting factor in these high end situations.