On Mon, Jan 11, 2010 at 10:49 AM, Baron Schwartz <ba...@xaprb.com> wrote:
> Victor, > > > That strikes me as messy. Each tmp table has as many rows as necessary > for > > the products that are to be bough. To do as you say I would have to > create a > > table with a zillion rows to accommodate however many products I > *predict* > > buyers would buy. Therefore, I guess I should probably create a new > database > > so as to not make a mess of the main database. > > You fundamentally misunderstand relational database design. I suggest > reading this book: > > http://www.xaprb.com/blog/2009/08/22/a-review-of-beginning-database-design-by-clare-churcher/ > LOL. Ok, I'll put it on my list. *In the meantime*, since I am reworking my database design for the shopping cart I just finished building and need to get this up __n_o_w__, what would your advice be? V > > Regards, > Baron > > -- > Baron Schwartz > Percona Inc: Services and Support for MySQL > http://www.percona.com/ > -- The Logos has come to bear http://logos.13gems.com/