Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 44666 invoked from network); 4 Feb 2010 23:02:08 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 4 Feb 2010 23:02:08 -0000 Received: (qmail 28062 invoked by uid 500); 4 Feb 2010 23:02:08 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 28008 invoked by uid 500); 4 Feb 2010 23:02:08 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 28000 invoked by uid 99); 4 Feb 2010 23:02:07 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 04 Feb 2010 23:02:07 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of david.vancouvering@gmail.com designates 209.85.216.204 as permitted sender) Received: from [209.85.216.204] (HELO mail-px0-f204.google.com) (209.85.216.204) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 04 Feb 2010 23:01:57 +0000 Received: by pxi42 with SMTP id 42so4383566pxi.5 for ; Thu, 04 Feb 2010 15:01:37 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:sender:received:date :x-google-sender-auth:message-id:subject:from:to:content-type; bh=TRq+HGdRPKzO5DnIOItImEuaTimNI3DBDaSVIogahIU=; b=iW+cKA2BDa/YOCpWnR4kEfudDTX0TjP994ZVE0Q/hEse701DQMZNhTD5rFVXGauZh1 FHRusanYx7Cx+vWb1QH19cSWmqKi7V2fS0jwpygKUs+aQpHtLBWA9Xciod8zAvOpCsAr nAej5UkNO1exNdSmDQzBuELx/K1Cl/TYITaJE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:date:x-google-sender-auth:message-id:subject :from:to:content-type; b=uF3IBI2urYdkVgOlfKgpVOQS3ZK7du0IICsEFLZFH4URr9c72vUUKGx2/S4Md3zcoY KYHXzWj89bKy+9c+jPXdBmKYxe5mKZRQznnPFA1Ba1iA/c3ISx80ITlKipiDMW+z3BE/ xHG2lOC4/iRr+7ZhnNRVobf69TNtJIPlzZKBg= MIME-Version: 1.0 Sender: david.vancouvering@gmail.com Received: by 10.140.56.14 with SMTP id e14mr1235622rva.19.1265324497353; Thu, 04 Feb 2010 15:01:37 -0800 (PST) Date: Thu, 4 Feb 2010 15:01:37 -0800 X-Google-Sender-Auth: e65eddd8b796fccf Message-ID: <56a83cd01002041501l276a67cbke6066129c85221ba@mail.gmail.com> Subject: Performance of in-place upgrade From: David Van Couvering To: Derby Discussion Content-Type: multipart/alternative; boundary=001636b2ac8630bb1f047ece510b --001636b2ac8630bb1f047ece510b Content-Type: text/plain; charset=ISO-8859-1 Hi, all. Yes, I'm now using Derby within the product I'm working on in my new job! :) So, I have some questions. I'll send separate emails for each ones to keep the threads simpler. I could have quite a few rows in my table - perhaps up to 100 million. The table will have about 5 columns. Do you have a sense of how long it will take to do a soft upgrade of a database of this size? Is it in the 1-9 minute range, 10-20 minutes, 1 hour, multiple hours? I can test this myself, but I was wondering if anyone could give me a quick ballpark. Thanks, David -- David W. Van Couvering http://www.linkedin.com/in/davidvc http://davidvancouvering.blogspot.com http://twitter.com/dcouvering --001636b2ac8630bb1f047ece510b Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi, all. =A0Yes, I'm now using Derby within the product I'm working= on in my new job! :)

So, I have some questions. =A0I= 9;ll send separate emails for each ones to keep the threads simpler.
<= div>
I could =A0have quite a few rows in my table - perhaps up to= 100 million. =A0The table will have about 5 columns. =A0Do you have a sens= e of how long it will take to do a soft upgrade of a database of this size?= =A0Is it in the 1-9 minute range, 10-20 minutes, 1 hour, multiple hours? = =A0I can test this myself, but I was wondering if anyone could give me a qu= ick ballpark.=A0

Thanks,

--001636b2ac8630bb1f047ece510b--