Those types of performance problems are easy to solve through the use of proper DB design and query caching. Further, you are going to need some sort of centralized persistent storage if you have more than one CF server.
-Matt > -----Original Message----- > From: Michael Tangorre [mailto:[EMAIL PROTECTED]] > Sent: Sunday, April 28, 2002 4:43 PM > To: CF-Talk > 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 > > > > > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
