Best practice stock management when payment of customer failed using SQL Server and ASP.NET

Question

Hi there,

I am currently building a webshop for my own where I want to increment the product-stock when the user fails to complete payment within 10 minutes after the customer placed the order. I want to gather information from this thread to make a design decision.

I am using SQL Server 2008 and ASP.NET 3.5. Should I use a SQL Server Job who intervals check the orders which are not payed yet or are there better solutions to do this.

Thanks in advance!

Martijn

Answer 1

Good question. I would work with a scheduled job. Run it every minute.

If the application is larger, a triggered application may also work (an exe that you start from the job scheduler in asp.net). Depends on the logic - I would not put more into the stored procedure than I have to in business logic, if you do stuff there that is more complicated - i would not put it into SQL.