Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP vs. SQL Server
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00165887
Message ID:
00165944
Vues:
17
>>VFP has astounding upper limits. The Universal Thread itself has 400,000 transactions per day. The Surplus Software site averages 30,000 visitors with a daily average of 85,000 to 125,000 transactions. Both sites have VFP back-ends.
>
>I hate to bring this up, but Surplus Direct switched to SQL Server because they had problems with VFP data corruption.

Index corruption. I am full of quotes today. :-)

"The Surplus site ran for over a year against local VFP data up to a volume of about 250,000 backend hits. The only problems that occurred had less to do with the volume of requests, but with data updates. The site needs to import new Inventory data several times a day and it was necessary to import it while the site was still running in live mode, while people were reading this data. This tended to corrupt indexes frequently causing mysterious crashes and data consistency errors."
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform