Shopping Cart: In Session or In Table

I am porting an ecommerce application from native ASP to ASP.NET.  Basically, a complete redesign.  

In the previous version, we kept all shopping cart info in a temp table in the database.  Unfortuantely, IIS has a bug in that the SessionOnEnd would not always fire, so occassionally, the temp table would have to be purged.  I don't want to have to worry about that this time around.

My question is, does it make more sense to store shopping cart info in a session object of ASP.NET or should it stay in a table?

If so, does anyone know if the SessionOn End in ASP.NET and newer versions of IIS are more reliable to fire as expected?
Who is Participating?
JackOfAll1Connect With a Mentor Commented:
I would always keep the information in a database table.  This allows people to return to finish shopping at a later time and better error recovery.  I do not use temp tables because they are lost on server restart.  If you need to purge temp tables a nightly script deleteing by date and/or time easily handles it.

Hope this helps.
NeoTeqConnect With a Mentor Commented:
Another thing to consider is that storing them in session will slow things down, especially when the shopping cart contains many different items.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.