[FX.php List] Shopping Carts - Keep in SessionVars or Add Records right away?

[Joel Shapiro]

Thanks for the quick response, Webko!

Do you have just one set of Orders & OrderItems tables, with some  
orders having status of "ordered" and some floating as "not  
ordered"?  Or do you have tandem Orders and "PreOrders" tables?

-Joel


On Jul 28, 2009, at 4:14 PM, Tim 'Webko' Booth wrote:

>
> On 29/07/2009, at 9:11 AM, Joel Shapiro wrote:
>
>> Hi all
>>
>> Anybody have any thoughts on *when* in shopping cart functionality  
>> it's best to add items as records to the database?
>>
>> My initial thinking is that it would make more sense to just keep  
>> items in Session Variable arrays and only add anything to the  
>> database at the time of Checkout -- to keep the DB from bulking up  
>> with unpurchased items left in the cart.  But searching online, it  
>> seems that carts often add records to the database as soon as they  
>> go into the cart.  (Might that be different when using MySQL as  
>> opposed to FMP?)
>>
>> FWIW - Users on this site will average 1-4 items per order.
>
> I tend to add them immediately - allows me to also re-show previous  
> not actually purchased items on request further down the track...
>
> Cheers
>
> Webko
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list