E R wrote:
On Wed, Mar 2, 2011 at 2:22 PM, Dan Cutler <dcut...@dsm.net> wrote:
Hi all!
I am seeking some advice.
I need to be able to drop several thousand (more like .25 million) tables from
a database using DBI.
2. How about just start using a brand-new database schema? Then you'll
start off with zero tables. Copy data from the original schema as
needed. Then you can drop the 250 K tables at your leisure.
I agree with this suggestion #2.
I would also ask why in tarnation would you have so many tables?
That may suggest a badly designed schema.
Or alternately you have zillions of mostly optional columns, such as for some
medical database, and you've decided to normalize them as far as possible, to
one table per non-key column.
But if you have lots of tables that are identical in structure and meaning, and
you're just partitioning, you're probably doing it wrong.
-- Darren Duncan
