MySQL Forums :: Transactions :: mysql innodb transaction concurrency
Re: mysql innodb transaction concurrency
Posted by: Peter Brawley ()
Date: August 06, 2011 12:57PM
> In products table, there is another field called max_can_sell_to_individual. I have to check the current inventory and also have to check the personal limit.
So build that logic into the transaction
> Now, I can maintain inventory but I have to check the individual limit also. That can be found from purchases table.
Ditto.
> And coming to you suggestion, if transaction fails, I have to refund money also. And that would incur transaction charges to client ans also users doesn't feel good.
Payment processing can be the last step of the transaction.
PB
So build that logic into the transaction
> Now, I can maintain inventory but I have to check the individual limit also. That can be found from purchases table.
Ditto.
> And coming to you suggestion, if transaction fails, I have to refund money also. And that would incur transaction charges to client ans also users doesn't feel good.
Payment processing can be the last step of the transaction.
PB
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.
© 2013, Oracle Corporation and/or its affiliates