Mike sql is set up as you know to handle alot more than what Coldfusion is set to handle. Why make the front end responsible for what the back-end should be processing.
"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:42 PM Subject: Re: Shopping Cart Opinions > 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 > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
