Re: Apache Derby performance disappointing

James Appleby wrote:
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?

My experience show that Derby perform well in INSERT, but are
clearly behind in SELECT.

So it may very well be as it is.

Arne
.

Relevant Pages

  • 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: ConnectionString using DSN not working
    ... applications that can work regardless of which backend database engine is ... This assumes that each DBMS is the same--supports the same SQL ... take advantage of the specific features you pay for when you buy SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Protecting database from administrators
    ... You're not the first looking for better security features, ... But, in their defence, MS want SQL Server as a mass-market ... dbms, so they put their resources into features that will earn them the most ...
    (microsoft.public.sqlserver.security)
  • Re: Selective views
    ... MS Access is an interactive, client interface for the MS Jet, ... semi-relational DBMS. ... If you create a MS Access database with links to SQL Server or pass-through ...
    (microsoft.public.sqlserver.server)
  • Re: DB or no DB?
    ... http://www.thezbuffer.com - News and information for Managed DirectX ... I think the question about whether to use a DBMS has been answered. ... Access or SQL Server Express? ...
    (microsoft.public.win32.programmer.directx.managed)