Return-Path: 
 <derby-user-return-9430-apmail-db-derby-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-user-archive@www.apache.org
Received: (qmail 39836 invoked from network); 19 Jun 2008 14:48:20 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 19 Jun 2008 14:48:20 -0000
Received: (qmail 56391 invoked by uid 500); 19 Jun 2008 14:48:21 -0000
Delivered-To: apmail-db-derby-user-archive@db.apache.org
Received: (qmail 55913 invoked by uid 500); 19 Jun 2008 14:48:20 -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 55902 invoked by uid 99); 19 Jun 2008 14:48:20 -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 07:48:20 -0700
X-ASF-Spam-Status: No, hits=2.0 required=10.0
	tests=HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of vodarus@gmail.com designates
 74.125.44.28 as permitted sender)
Received: from [74.125.44.28] (HELO yx-out-2324.google.com) (74.125.44.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 19 Jun 2008 14:47:31 +0000
Received: by yx-out-2324.google.com with SMTP id 3so127493yxj.85
        for <derby-user@db.apache.org>; Thu, 19 Jun 2008 07:47:49 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:received:received:message-id:date:from:to
         :subject:in-reply-to:mime-version:content-type:references;
        bh=saJW4taq+/1ZNfZqtccnon5P445AkzMIa460giMIJyo=;
        b=NLpAlBaRr4S8+/kjCRdhtMpNnqh7bqZvBUcu6hMCkhwPo1mS5EjQjYGb4X96TDXdsM
         yGajWheD+OszoGmiTFVJ5P2GTutNGKP/b6calMitt/RgYi07zTXwr15zKAl5ZFnFQaAA
         1jsx72b8ueUsMyKgzSfkdiJHYWCC7MSEsuhhg=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version
         :content-type:references;
        b=GIyLOXuYPB1bOG15L94CQukodSwFTqQ8JWMbaknISApbWu/jT6GRiKLcRIic+ZOOID
         d5i2vRetJBhrFh0dHtQh0tKGuQ4IvgJTDM92w/WJl4bk3Jkm9QCFQiacjDTB+X2+MIQG
         itkpxSPPo/CEz/Fembf6bzXjS7X5u+jzAVMyg=
Received: by 10.143.5.21 with SMTP id h21mr964627wfi.175.1213886868555;
        Thu, 19 Jun 2008 07:47:48 -0700 (PDT)
Received: by 10.151.99.19 with HTTP; Thu, 19 Jun 2008 07:47:48 -0700 (PDT)
Message-ID: <1c6e34b0806190747s348142bdha92af894cf68eab2@mail.gmail.com>
Date: Thu, 19 Jun 2008 18:47:48 +0400
From: "vodarus vodarus" <vodarus@gmail.com>
To: "Derby Discussion" <derby-user@db.apache.org>
Subject: Re: Speed of using Derby DB
In-Reply-To: <485A5673.90301@Sun.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_4671_20974850.1213886868562"
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>
X-Virus-Checked: Checked by ClamAV on apache.org

------=_Part_4671_20974850.1213886868562
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_4671_20974850.1213886868562
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_4671_20974850.1213886868562--