List:General Discussion« Previous MessageNext Message »
From:Baron Schwartz Date:January 11 2010 2:49pm
Subject:Re: tmp tables
View as plain text  
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/

Regards,
Baron

-- 
Baron Schwartz
Percona Inc: Services and Support for MySQL
http://www.percona.com/
Thread
tmp tablesVictor Subervi10 Jan
  • Re: tmp tablesBaron Schwartz11 Jan
    • Re: tmp tablesVictor Subervi11 Jan
      • Re: tmp tablesBaron Schwartz11 Jan
        • Re: tmp tablesVictor Subervi11 Jan
          • Re: tmp tablesKeith Murphy11 Jan
            • Re: tmp tablesVictor Subervi11 Jan
          • Re: tmp tablesJohnny Withers11 Jan
            • Re: tmp tablesmos12 Jan
              • Re: tmp tablesVictor Subervi13 Jan
                • Re: tmp tablesJohnny Withers13 Jan
                  • Re: tmp tablesVictor Subervi13 Jan
                    • Re: tmp tablesChris W14 Jan
                      • Re: tmp tablesVictor Subervi15 Jan