[ANNOUNCE] Apache Derby 10.5.3.0 released

[Rick Hillegas <Ri...@Sun.COM>]

The Apache Derby project is pleased to announce a new bug-fix release of 
Derby, 10.5.3.0.

Apache Derby is a subproject of the Apache DB project. Derby is a pure 
Java relational database engine which conforms to the ISO/ANSI SQL and 
JDBC standards. Derby aims to be easy for developers and customers to use.

Derby 10.5.3.0 can be obtained from the Apache download site:

  http://db.apache.org/derby/derby_downloads.html


Derby 10.5.3.0 contains many bug fixes plus localizations for messages 
added in the previous feature release, 10.5.1.1. 10.5.3.0 replaces 
10.5.2.0, which introduced a query-ordering regression.

Please try out 10.5.3.0.

Re: [ANNOUNCE] Apache Derby 10.5.3.0 released

[bruehlicke <br...@gmail.com>]

Just upgraded from 10.4.1.3

Wow.  Is it only me or is this version noticable faster for inserts
and table creation than the 10.4.1.3 release ?

Thanx !
B-)

On 8/26/09, Rick Hillegas <Ri...@sun.com> wrote:
> The Apache Derby project is pleased to announce a new bug-fix release of
> Derby, 10.5.3.0.
>
>  Apache Derby is a subproject of the Apache DB project. Derby is a pure Java
> relational database engine which conforms to the ISO/ANSI SQL and JDBC
> standards. Derby aims to be easy for developers and customers to use.
>
>  Derby 10.5.3.0 can be obtained from the Apache download site:
>
>   http://db.apache.org/derby/derby_downloads.html
>
>
>  Derby 10.5.3.0 contains many bug fixes plus localizations for messages
> added in the previous feature release, 10.5.1.1. 10.5.3.0 replaces 10.5.2.0,
> which introduced a query-ordering regression.
>
>  Please try out 10.5.3.0.
>
>

derby performance

[Brian Spindler <bs...@netuitive.com>]

Hi all, 

For Both Questions: Data and Log are on same drive and separating isn't
really an option, we're using embedded version.

+---Question #1 ---------+
I have an operation consisting of deleting 125K rows from 3 tables,
first table takes 50s, second table takes >6mins and the third 2.5min.
11min total so I have 2min worth of optimizing just on JAVA side but I
can't seem to make any headway on optimizing derby performance.

I'm using 10.4, Embedded version; my question is why the differences in
time?  I've got my system pretty isolated and I can see the disk is
pegged but other than a max of 5column difference the tables are
similar.  The deletes are all executed and then committed in at the end.
+-------------------------+


+---Question #2 ---------+
Seems I have a similar problem for inserting into the database,
inserting take on order of 7mins to get all rows into database.  In this
case all rows inserted in random chunks across all three tables but
again, I can see disk pegged but from logs it seems Derby is fast then
slow, and then fast again.  

I'm running with mainly all defaults, PreparedStatements are reused
across insert operations. 
+-------------------------+


Any thoughts? 

Thanks!!

-Brian