I'm developing a shopping cart portal and I have functionality to store the cart details in database. Since there will be multiple products in the cart, what will be the better way to store the product details in the database. I don't prefer to call insert
product stored procedure for each item in the cart. Instead what will be the efficient way by calling insert product stored procedure only once and pass the entire cart items as input to the procedure. I am thinking of placing cart items in XML content and
pass it to stored procedure as XML input. Is there any other better way to achieve this?
Go to the complete details ...