Re: MySQL million tables

On 3/9/06, Stefan 'Kaishakunin' Schumacher <stefan(at)net-tex(dot)de> wrote:
>
> Also sprach Christopher Kings-Lynne (chriskl(at)familyhealth(dot)com(dot)au)
> > I see in this post on planetmysql.org that this guy got MySQL to die
> > after creating 250k tables. Anyone want to see how far PostgreSQL can
> > go? :)
> >
> > http://bobfield.blogspot.com/2006/03/million-tables.html
> >
> > Also, can we beat his estimate of 27 hours for creation?
>
> for i in `seq 1 1000000`;
> do
> echo "create table test$i (ts timestamp);"|psql tabletorture;
> done

My results were based on 500 CREATE TABLE's per transaction, so my results
aren't comparable either.

--
Jonah H. Harris, Database Internals Architect
EnterpriseDB Corporation
732.331.1324