From derby-user-return-12075-apmail-db-derby-user-archive=db.apache.org@db.apache.org Tue Jan 12 03:14:16 2010
Return-Path: <derby-user-return-12075-apmail-db-derby-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-user-archive@www.apache.org
Received: (qmail 84801 invoked from network); 12 Jan 2010 03:14:16 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 12 Jan 2010 03:14:16 -0000
Received: (qmail 431 invoked by uid 500); 12 Jan 2010 03:14:16 -0000
Delivered-To: apmail-db-derby-user-archive@db.apache.org
Received: (qmail 293 invoked by uid 500); 12 Jan 2010 03:14:15 -0000
Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:derby-user-help@db.apache.org>
list-unsubscribe: <mailto:derby-user-unsubscribe@db.apache.org>
List-Post: <mailto:derby-user@db.apache.org>
List-Id: <derby-user.db.apache.org>
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Delivered-To: mailing list derby-user@db.apache.org
Received: (qmail 285 invoked by uid 99); 12 Jan 2010 03:14:15 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Jan 2010 03:14:15 +0000
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: local policy)
Received: from [63.82.107.6] (HELO red.amberpoint.com) (63.82.107.6)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Jan 2010 03:14:08 +0000
Received: from [127.0.0.1] (steve-popes-macbook-pro.local [10.10.12.252] (may be forged))
	by red.amberpoint.com (8.13.8/8.13.8) with ESMTP id o0C3Dj5C029490
	for <derby-user@db.apache.org>; Mon, 11 Jan 2010 19:13:46 -0800
Message-ID: <4B4BE8E9.9020405@amberpoint.com>
Date: Mon, 11 Jan 2010 19:13:45 -0800
From: Bryan Pendleton <bpendleton@amberpoint.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
To: Derby Discussion <derby-user@db.apache.org>
Subject: Re: delete from table
References: <4B4B9C7A.6030901@absinth.fi>
In-Reply-To: <4B4B9C7A.6030901@absinth.fi>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

> It seems that deleting a table takes a VERY long time.

As an alternative, you can try DROP TABLE and then CREATE TABLE,
and see if that is faster.

thanks,

bryan