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

--------------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--