Victor, On Sun, Jan 10, 2010 at 1:20 PM, Victor Subervi <victorsube...@gmail.com> 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/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org