>>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement