Slow delete

From: David Turner <dturner_at_linuxcare.com>
Date: Mon, 26 Jun 2000 05:57:54 -0700
Message-Id: <10540.110412@fatcity.com>

--------------74496A96527D2A6AEE39E794
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Any idea why a delete of all the rows in a table might take hours when there are only 30,000 rows? There are no other users on the system. Rowlength is about 120.

Dave Turner

--
Dave Turner, Senior Database Administrator, Linuxcare, Inc.
913.383.3052 tel, 913.579.3803 cel, 913.652.0687 fax, 877.443.9553 pager
dturner@linuxcare.com, http://www.linuxcare.com/
Linuxcare. Support for the revolution.
--



--------------74496A96527D2A6AEE39E794
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit



<!doctype html public "-//w3c//dtd html 4.0 transitional//en">

<html>

Any idea why a delete of all the rows in a table might take hours when
there are only 30,000 rows? There are no other users on the system. Rowlength
is about 120.


<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

Dave Turner


<pre>--

Dave Turner, Senior Database Administrator, Linuxcare, Inc.
913.383.3052 tel, 913.579.3803 cel, 913.652.0687 fax, 877.443.9553 pager&nbsp;
dturner@linuxcare.com, <A HREF="http://www.linuxcare.com/">http://www.linuxcare.com/</A>
Linuxcare. Support for the revolution.
--</pre>
&nbsp;</html>

--------------74496A96527D2A6AEE39E794--

Received on Mon Jun 26 2000 - 07:57:54 CDT