Of course, the database where you store the session data doesn't have to be the same database as the one in which you store completed orders, or even on the same server.
When you're starting out it probably makes sense for it to be on the same server, or even different tables in the same database but as you grow you can progressively move it to a different database and then to a different server. On Thu, Jul 22, 2010 at 11:02 PM, nicolaas <[email protected]> wrote: > +1 for thanking you for all your comments > > By the sound of it, the main thing stopping someone from saving cart > data in the database is the resource usage (bloated database, slow > connection, bottleneck). I reckon this is best solved by improving: > * connection to DB > * writing smarter queries > * indexes > etc... > > rather than trying to craete a temporary database system in the form > of a session. A database will always be a better place to save data > then a session. > > One thing you will have to do if course is to link the data in the > database to a session. Otherwise, storing cart data in the database > will require a user login / sign-up - which is unattractive from a > usability perspective. > > On the other hand, an order saved to be DB can be retrieved from a > different location if the user does save his / her order. Also, with > orders saved in the database, it is easier to have several orders on > the go at once (and switch between them), something that would be > tricky to achieve with sessions. For some e-commerce situations this > could be useful. > > Does anyone know how famous ecommerce systems do it (e.g. Magento)? > > Nicolaas > > -- > NZ PHP Users Group: http://groups.google.com/group/nzphpug > To post, send email to [email protected] > To unsubscribe, send email to > [email protected] > -- Bruce Clement Home: http://www.clement.co.nz/ Twitter: http://twitter.com/Bruce_Clement Google Buzz: http://www.google.com/profiles/aotearoanz "Before attempting to create something new, it is vital to have a good appreciation of everything that already exists in this field." Mikhail Kalashnikov -- NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected]
