Return-Path: 
 <derby-user-return-9431-apmail-db-derby-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-user-archive@www.apache.org
Received: (qmail 73726 invoked from network); 19 Jun 2008 15:07:44 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 19 Jun 2008 15:07:44 -0000
Received: (qmail 1778 invoked by uid 500); 19 Jun 2008 15:07:44 -0000
Delivered-To: apmail-db-derby-user-archive@db.apache.org
Received: (qmail 1756 invoked by uid 500); 19 Jun 2008 15:07:44 -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 1745 invoked by uid 99); 19 Jun 2008 15:07:44 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 19 Jun 2008 08:07:44 -0700
X-ASF-Spam-Status: No, hits=-1.0 required=10.0
	tests=RCVD_IN_DNSWL_LOW,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: local policy)
Received: from [192.18.6.21] (HELO gmp-eb-inf-1.sun.com) (192.18.6.21)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 19 Jun 2008 15:06:52 +0000
Received: from fe-emea-09.sun.com (gmp-eb-lb-2-fe3.eu.sun.com [192.18.6.12])
	by gmp-eb-inf-1.sun.com (8.13.7+Sun/8.12.9) with ESMTP id m5JF6ow1025827
	for <derby-user@db.apache.org>; Thu, 19 Jun 2008 15:07:03 GMT
Received: from conversion-daemon.fe-emea-09.sun.com by fe-emea-09.sun.com
 (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007))
 id <0K2P00F01TOJHM00@fe-emea-09.sun.com>
 (original mail from Kristian.Waagan@Sun.COM) for derby-user@db.apache.org;
 Thu, 19 Jun 2008 16:06:50 +0100 (BST)
Received: from [129.159.112.237] by fe-emea-09.sun.com
 (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007))
 with ESMTPSA id <0K2P00H6BTZ1YSH0@fe-emea-09.sun.com> for
 derby-user@db.apache.org; Thu, 19 Jun 2008 16:06:38 +0100 (BST)
Date: Thu, 19 Jun 2008 17:06:37 +0200
From: Kristian Waagan <Kristian.Waagan@Sun.COM>
Subject: Re: Speed of using Derby DB
In-reply-to: <1c6e34b0806190747s348142bdha92af894cf68eab2@mail.gmail.com>
Sender: Kristian.Waagan@Sun.COM
To: Derby Discussion <derby-user@db.apache.org>
Message-id: <485A75FD.5060208@Sun.com>
Organization: Sun Microsystems Inc.
MIME-version: 1.0
Content-type: text/plain; format=flowed; charset=UTF-8
Content-transfer-encoding: 7BIT
References: <1c6e34b0806110131q12339641j841b8c5861f0085a@mail.gmail.com>
 <48506269.3010107@sbcglobal.net>
 <1c6e34b0806160319kc7d46c7q63a8666ccfdd96f@mail.gmail.com>
 <1c6e34b0806180433w38f1660fp9ac46dc44accbe9@mail.gmail.com>
 <48593A29.2030202@Sun.com>
 <1c6e34b0806190142p17f7c917sf679c15b430d1b17@mail.gmail.com>
 <485A5673.90301@Sun.com>
 <1c6e34b0806190747s348142bdha92af894cf68eab2@mail.gmail.com>
User-Agent: Mozilla/5.0 (X11; U; SunOS i86pc; no-NO; rv:1.8.1.14)
 Gecko/20080519 Thunderbird/2.0.0.14 Mnenhy/0.7.5.0
X-Virus-Checked: Checked by ClamAV on apache.org

vodarus vodarus wrote:
> Also interesting that DROP and CREATE <table> seems to be faster than 
> DELETE FROM <table>
> 
> it depends on internal architecture.
> by the way... Is Derby have blocking engine (like MySQL/MyISAM or MS SQL 
> 2k) or versionning (like PostgreSQL or Oracle)?

Derby uses locking.
Row and table level locking are supported.


-- 
Kristian