Re: tmp tables

[Baron Schwartz]

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/