From: Carsten Pedersen Date: April 14 2010 9:02pm Subject: Re:
Make delete requests without impact on a database List-Archive:
Message-Id: <> MIME-Version: 1.0 Content-Type: text/plain;
charset=ISO-8859-1; format=flowed Content-Transfer-Encoding:
7bit mos skrev: > At 01:20 PM 4/14/2010, Carsten Pedersen wrote:
>> Been there, done that. It's a maintenance nightmare. > > Why
is it a maintenance nightmare? I've been using this technique
for a > couple of years to store large amounts of data and it
has been working > just fine. In a previous reply, you mentioned
splitting the tables on a daily basis, not yearly. Enormous
difference. It's one thing to fiddle with a set of merge table
once a year to create a new instance. Quite another when it's to
be done every day. If you want to change the table structure,
you'll have to do that on every single one of the underlying
tables. That might be fine for 5 year-tables, but not fun if you
need to do it for hundreds of tables. If your merge table
consists of 30 underlying