Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Inherent limitation on transaction volume in VFP?
Message
De
07/05/2003 11:14:00
 
 
À
06/05/2003 16:19:20
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00785565
Message ID:
00785838
Vues:
29
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform