Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP vs. SQL Server
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00165887
Message ID:
00165944
Views:
25
>>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."
Previous
Reply
Map
View

Click here to load this message in the networking platform