Return-Path: 
 <derby-user-return-4546-apmail-db-derby-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-user-archive@www.apache.org
Received: (qmail 72262 invoked from network); 6 Jul 2006 10:44:18 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 6 Jul 2006 10:44:18 -0000
Received: (qmail 33174 invoked by uid 500); 6 Jul 2006 10:44:17 -0000
Delivered-To: apmail-db-derby-user-archive@db.apache.org
Received: (qmail 33038 invoked by uid 500); 6 Jul 2006 10:44:16 -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 33027 invoked by uid 99); 6 Jul 2006 10:44:16 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 06 Jul 2006 03:44:16 -0700
X-ASF-Spam-Status: No, hits=1.4 required=10.0
	tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_WHOIS
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [68.142.207.84] (HELO web31904.mail.mud.yahoo.com)
 (68.142.207.84)
    by apache.org (qpsmtpd/0.29) with SMTP; Thu, 06 Jul 2006 03:44:15 -0700
Received: (qmail 63262 invoked by uid 60001); 6 Jul 2006 10:43:54 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Message-ID:Received:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type;
  b=nHxR/9ROcn6QoBM0kqUYr6f0+/tOBnLL7npwoARkvnayLD1l+wIon/UsBnRBdjj3HPgHHQHfMqMIL2rr8qllGXb7pcper8tVaDblkWs03ily5aF9tZ3bHCjwJs/O7V6rNs35ytGJ3YcSQg1uKPwzt7GzRINaye7VLfEzq23hbWc=
  ;
Message-ID: <20060706104354.63260.qmail@web31904.mail.mud.yahoo.com>
Received: from [67.68.17.32] by web31904.mail.mud.yahoo.com via HTTP;
 Thu, 06 Jul 2006 03:43:54 PDT
Date: Thu, 6 Jul 2006 03:43:54 -0700 (PDT)
From: Leslie Software <lesliesoftware@yahoo.com>
Reply-To: Leslie Software <lesliesoftware@yahoo.com>
Subject: Re: Re: Trouble accessing read only DB with 10.1 (created and
 accessed fine with 10.0)
To: Derby Discussion <derby-user@db.apache.org>
In-Reply-To: <54ac72d70607060000r2518a529q72cb3b6f3d63b961@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

That makes sence - from the error I would never have thought that.  

Your proceedure for upgrading the DB worked great.  I am back up and running happily with a 10.1 database - almost.  My small version of the database is OK its size barely changed.  - Thanks!!!

My larger database went from 2.8Mb to 1.7Mb after the conversion.  I was suspicious about that and when I tried it the performace was a lot lower then I it used to be (actions that took 2s are now taking 8s).  Is it possible that the indexes need to be rebuilt?  I was guessing indexes when I saw the size decrease - just speculation on my part.

Did I miss an upgrade section in the documentation that I should be reading?  I found this <http://wiki.apache.org/db-derby/UpgradingTen> which does seem to indicate that a full upgrade will result in a db that uses less space but says nothing about any performace changes.

Thanks for your help Andrew.  Any thoughts on the performace change would be appreciated.

Thanks,

Ian
 
----- Original Message ----
From: Andrew McIntyre <mcintyre.a@gmail.com>

<snip>
"Databases in a jar or zip file are always opened read-only and there
is currently no support to allow updates of any type."
<snip>