db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Leslie Software <lesliesoftw...@yahoo.com>
Subject Re: Re: Trouble accessing read only DB with 10.1 (created and accessed fine with 10.0)
Date Thu, 06 Jul 2006 10:43:54 GMT
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>




Mime
View raw message