Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Inherent limitation on transaction volume in VFP?
Message
From
07/05/2003 11:14:00
 
 
To
06/05/2003 16:19:20
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00785565
Message ID:
00785838
Views:
26
Thanks for the suggestions. We've been working on a plan to test our application under that kind of load, but it takes some work to accurately simulate 300 or so users ringing up sales, etc. I'm not too worried about the application logic choking, or the hardware being underpowered (you can always cluster the servers or add more RAM) I'm more worried that we'll run into a bottleneck with the VFP database engine under very heavy load. I'm starting to think we need to talk to someone at MS to get some hard data on this.

>There is no inherent limitation on transaction processing capacity in VFP. You run it on faster hardware, you get more transactions per second.
>
>I can't offer any real world experience. It sounds like you already have significant experience with TS. If so, you could track your existing 75-user server and check various loads - CPU, RAM, disk etc. This will give you some idea how much hardware you'd theoretically need to handle quadrupling up to 300 users - then you can see if that hardware exists.
>
>You might be able to do some testing when (if) your existing server is at low or no load. Create a test app that uses a timer to generate representative (i.e. demanding) transactions against a test VFP database. Run a few instances of that on your server and you can easily simulate any transaction load you'd like.
>
>Or, if a vendor wants to sell you a hot box to support 300 users, you could take that test app in and run it before you buy.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform