If I change the oc_cart table to MyISAM engine, This is the reason for the negative result of it?liquidpele wrote:This is actually a pretty big problem - a busy site might have 3 people trying to buy the same thing at the same time! The answer is: Just have the database handle it for you.
Make the table you track the carts/stock with InnoDB instead of myISAM. Then track the cart/stock in that table and use table locks to verify things if you're verifying and then updating the table. The performance doesn't matter if the only thing using the locking table are people with carts because you're not going to have 200 people checking out and refreshing at the same time and having good concurrency is more important.
If the result is negative because of this, that if I changed back to the original InnoDB is not able to solve it?
PS.I can be empty oc_cart the table, let it be recalculated?
MY OpenCart 126.96.36.199