Re: Apache Derby performance disappointing

On 16 Aug, 15:02, James Appleby <james.w.appl...@xxxxxxxxx> wrote:
Hello,

I am currently adding Derby support to an application that already has
support for multiple DBMS via JDBC. I have found it to be
significantly slower than SQL Server or MySQL when performing the same
task. To provide this, I have created an exact duplicate database
within both Derby and SQL Server and ran the same query on both,
gathering timings.

The test query returns about 16,000 rows from a table with about
100,000 on it, grouping data using a timestamp that is converted to
the nearest second. This is one of the heaviest queries within the
application and what chosen to put the DBMS under the most strain. To
prevent caching interferring with the result, I made sure to restart
the DBMS before running the query.

SQL Server was at least 4 times quicker returning the results compared
to Derby. I had expected SQL Server to outperform Derby, but not by
such a huge factor. Is this result what is expected?

The initial test was based on a default, untuned installation. I then
followed tuning guidelines for Derby, increasing the page size to 32K
and increasing the maximum page count to far in excess of what should
be needed to return the amount of data I am testing. This gave some
improvements but it is still takes three times that of the same query
time on SQL Server.

As Derby is marketing itself on the same level as MySQL (Apache
provide performance figures comparing it to this) then I anticipated
similiar performance, but instead it is taking twice as long as I
consider reasonable. Is this in line with anyone elses experience?

I presume you created all indexes which exist on SQL server?

.

Relevant Pages

  • Apache Derby performance disappointing
    ... I am currently adding Derby support to an application that already has ... significantly slower than SQL Server or MySQL when performing the same ... The test query returns about 16,000 rows from a table with about ... application and what chosen to put the DBMS under the most strain. ...
    (comp.lang.java.databases)
  • Re: Apache Derby performance disappointing
    ... significantly slower than SQL Server or MySQL when performing the same ... within both Derby and SQL Server and ran the same query on both, ... The test query returns about 16,000 rows from a table with about ... application and what chosen to put the DBMS under the most strain. ...
    (comp.lang.java.databases)
  • Re: JavaDB / Apache Derby equivalent to the SQL Server IsNull, Oracle nvl and MySQL IfNull
    ... already has support for Oracle, ... In SQL Server the function is called: ... In MySQL the function is called: ... I can't find an equivalent for Derby. ...
    (comp.lang.java.databases)
  • Re: CRecordSet and Table Indexes
    ... If the DBMS is SQL Server or one of the later versions of MS ... Server if you wish to tune your queries and see which indexes are used after ... you can run the queries in Query Analyser using 'Show ...
    (microsoft.public.vc.mfc)
  • Re: Syntax of derby db & squirrel-sql
    ... I am looking for a tutorial for the sql of Derby. ... other words, the DBMS and application run on the same computer, the DBMS does not have to be separately started outside the application. ... Use the client-server driver to access a shared database from one or more client applications on other computers. ...
    (comp.lang.java.programmer)