List:General Discussion« Previous MessageNext Message »
From:Baron Schwartz Date:January 11 2010 2:35pm
Subject:Re: tmp tables
View as plain text  
Victor,

On Sun, Jan 10, 2010 at 1:20 PM, Victor Subervi <victorsubervi@stripped> wrote:
> Hi;
> I have a shopping cart that will spawn a tmp table for every shopping cart
> instance. Would it be better to create a separate database for these instead
> of having them in the same database as all the other tables for the shopping
> cart?

It will not matter at all.  But it would be better to choose a
different design.  Instead of adding a table per cart, just create a
table and add a row(s) to it for every cart.  This is what relational
databases were designed for :-)

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