Re: MySQL million tables

Another mysql blogger has chimed in now:

http://arjen-lentz.livejournal.com/66547.html

He did it with MyISAM tables though.

Chris

Jonah H. Harris wrote:
> On 3/9/06, *Christopher Kings-Lynne* <chriskl(at)familyhealth(dot)com(dot)au
> <mailto:chriskl(at)familyhealth(dot)com(dot)au>> wrote:
>
> Also, can we beat his estimate of 27 hours for creation?
>
>
> I just tried it on my a Thinkpad:(Pentium M @ 1.73GHz) running SuSE 10
> and an untuned PostgreSQL 8.1.3 using a shell script and psql. I was
> able to create 274,000 tables in exactly 798 seconds.
>
> And it's still chugging away :)
>
>
> Chris
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
>
>
>
> --
> Jonah H. Harris, Database Internals Architect
> EnterpriseDB Corporation
> 732.331.1324