Mailing List Archive


Back to the month index Back to the list index
yuq-msql@wayx.com
Wed, 12 Nov 1997 13:19:25 +0800 

From: yuq-msql@wayx.com
Message-Id: <3.0.32.19971112131911.006867c4@marcus>
Date: Wed, 12 Nov 1997 13:19:25 +0800
Subject: H~e~l~p~,how can I REALLY delete!!!!!!!!!!!

hi,all

It is me again.why no one answered me?My customer are going to kill me
tomorrow if I can not REALLY delete !

This time ,my question is about delete.
Does the statement "Delete from <tablename> where <logic conditions>
"REALLY delete the contents physcially?I found the delete statement is
something LOGICALLY,it doesn't REALLY REMOVE those rows from physcial
files.How can I REALLY DELETE those rows ,so I can reduce the file size?

thanks
any advice please mail to yuq-msql@wayx.com
you are higly appreciately.
johnny.
From mke@netcom.com Wed Nov 12 01:06:44 1997
Received: from terrapin.turbolift.com (mg136-138.ricochet.net [204.179.136.138])
        by services.bunyip.com (8.8.5/8.8.5) with ESMTP id BAA24497
        for <msql-list@services.bunyip.com>; Wed, 12 Nov 1997 01:06:41 -0500 (EST)
Received: from timebox.llnl.gov (timebox.turbolift.com [128.115.138.80])
          by terrapin.turbolift.com (8.8.5/TERRAPIN-4.0.3) with SMTP
          id WAA22612; Tue, 11 Nov 1997 22:06:24 -0800 (PST)
Date: Tue, 11 Nov 1997 22:06:23 -0800 (PST)
From: "Michael J. Miller Jr." <mke@netcom.com>
X-Sender: mke@timebox.llnl.gov
To: yuq-msql@wayx.com
cc: Multiple recipients of list <msql-list@services.bunyip.com>
Subject: Re: H~e~l~p~,how can I REALLY delete!!!!!!!!!!!
In-Reply-To: <3.0.32.19971112131911.006867c4@marcus>
Message-ID: <Pine.SOL.3.96.971111220414.1341B-100000@timebox.llnl.gov>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

On Wed, 12 Nov 1997 yuq-msql@wayx.com wrote:

> hi,all
>
> It is me again.why no one answered me?My customer are going to kill me
> tomorrow if I can not REALLY delete !
>
>
> This time ,my question is about delete.
> Does the statement "Delete from <tablename> where <logic conditions>
> "REALLY delete the contents physcially?I found the delete statement is
> something LOGICALLY,it doesn't REALLY REMOVE those rows from physcial
> files.How can I REALLY DELETE those rows ,so I can reduce the file size?

Trust me, you don't want to. The overhead of doing this in real time
is just way to high. If you must, dump the database, delete it and
re-import the data.

Disk space is CHEAP. If you're not running into file size or partitions
size limitations then your customer is being penny wise and pound foolish.
(To quote a phrase my English born mother often uses.)

Mike Miller mke@netcom.com