Mailing-List: contact dev-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@jackrabbit.apache.org
Received-SPF: pass (athena.apache.org: domain of stefan.guggisberg@gmail.com
 designates 209.85.218.227 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=EIn2n+z9ez5JMh+3VSR/SLyH7nYWh6KcUQaRuiM/EHNysMFZZmameVar2W9tHJBD03
         OoBomR6aCKRXQdC9sAc0Usd8vxjUm/AkJ4+cXj9HeRg3daqJs7nbtaGRWiMLG3yxG/24
         /0UDaZKBc4uokxdBZM1qga3FJgzxRA7z7AYAk=
MIME-Version: 1.0
In-Reply-To: <-4734217744141202942@unknownmsgid>
References: <-4734217744141202942@unknownmsgid>
Date: Wed, 30 Sep 2009 13:39:22 +0200
Message-ID: <90a8d1c00909300439q599f53c6nc070a36082484b38@mail.gmail.com>
Subject: Re: Performance: Apache Derby vs. Oracle
From: Stefan Guggisberg <stefan.guggisberg@gmail.com>
To: dev@jackrabbit.apache.org
Content-Type: text/plain; charset=ISO-8859-1

On Wed, Sep 30, 2009 at 1:05 PM, David Wagener <David.Wagener@awi.de> wrote:
> Hello,
>
>
>
> I have analysed the performance of my application based on apache derby
> (default configuration) and based on oracle.
>
> The application based on apache derby (default configuration) is faster.
>
>
>
> Can you describe me the reasons?!

well, why does this come as a surprise?;)

1. you probably used an embedded derby db whereas oracle is a
stand-alone server.
   => network latency
2. oracle has never been known to be blazingly fast ;) derby
stand-alone server or
   e.g. mysql should provide significantly better performance.

cheers
stefan

2.
>
>
>
> I think it is the time to take index data and the time to read the items of
> the resultset with JDDB.
>
> Do you agree?
>
>
>
> Thank you a lot!
>
>
>
> Greetings!
>
>
>
> David