Doug, Woudl the performace degrade with all the transmission of data between the client and the DB everytime a cart process needed to occur? I see what you are saying however... I am just pooling ideas and thoughts here...
Mike ----- Original Message ----- From: "Douglas Brown" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, April 28, 2002 7:44 PM Subject: Re: Shopping Cart Opinions > Hey, what about just using a database instead of using structures > or arrays? That is pretty much what sql is for. The performance > would be alot faster and you would also be able to track people > who did not complete the shopping experience and track what items > are most opoular that people are looking at and maybe not > buying....maybe the proce is too high and they found cheaper > elsewhere. > > > > > "Success is a journey, not a destination!!" > > > > Doug Brown > ----- Original Message ----- > From: "Michael Tangorre" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Sunday, April 28, 2002 4:32 PM > Subject: Re: Shopping Cart Opinions > > > > ok man, thanks for being so blunt! > > It's the first time i've approached the idea of building a cart > so chill. > > > > > > ----- Original Message ----- > > From: "Matt Liotta" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Sunday, April 28, 2002 7:22 PM > > Subject: RE: Shopping Cart Opinions > > > > > > > Using lists this way is such a bad idea it isn't even funny. > As soon as > > > the lists start to grow your performance is going to be shit. > > > > > > -Matt > > > > > > > -----Original Message----- > > > > From: Michael Tangorre [mailto:[EMAIL PROTECTED]] > > > > Sent: Sunday, April 28, 2002 3:00 PM > > > > To: CF-Talk > > > > Subject: Shopping Cart Opinions > > > > > > > > Hi everyone. > > > > > > > > I have just created a simple shopping cart and wanted to get > some > > > thoughts > > > > on my approach to it. > > > > > > > > I create a structure of lists which is stored in the session > scope. > > > > > > > > 1. cart.quantities > > > > 2. cart.prices > > > > 3. cart.products > > > > > > > > Basically every time I (add/remove/changeqty) a product, I > go through > > > and > > > > make changes to the three lists: > > > > > > > > Example: > > > > > > > > products list (holds product IDs) 1001, 1002, 1003, 1004 > > > > price list (hold price for sinlge product) 5.99, 6.45, 2.50, > 8.99 > > > > quantity (holds quantity of product added) 2, 4, 1, 1 > > > > > > > > So basically everytime I perform an operation, I use > ListFind to get > > > the > > > > position in the list of the product whose ID is passed into > the page. > > > > Using that location of the product in the list, I just > perform simple > > > > insertions, deletions, and updates using the location. > > > > > > > > Does anyone see any downsides to this method? > > > > I build another cart using arrays, and the execution times > for the > > > > templates were considerably longer. > > > > > > > > Hit me back with some pros and cons or comments. > > > > > > > > Thanks, > > > > Mike > > > > > > > > > > > > > > > > > > > > > > __________________________________________________________________ > ____ > > Signup for the Fusion Authority news alert and keep up with the > latest news in ColdFusion and related topics. > http://www.fusionauthority.com/signup.cfm > > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > > Archives: http://www.mail-archive.com/[email protected]/ > > Unsubscribe: > http://www.houseoffusion.com/index.cfm?sidebar=lists > > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
