Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: domain of paulschein@gmail.com
 designates 64.233.162.237 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition;
        b=dTuNaa7eC0KTVVHQoJ/powRJoW+6TQJvvDwEZtDcl8gSxc7Jq6l1E6cQrTcwdu/nVDBpCP09ICnkkISSUEs91PylDu+qufX7oMyxac0TBVz1SaQuA5UhDPE9tg4cbfC/tz0HaSwRIpcM9mN7jmYRWW/uyskVyVjUR5lpkNc3eg8=
Message-ID: <ee3760eb0709030733y4fe67cby58eaee69ccf54872@mail.gmail.com>
Date: Mon, 3 Sep 2007 15:33:27 +0100
From: "Paulo Jesus" <paulschein@gmail.com>
To: "Derby Discussion" <derby-user@db.apache.org>
Subject: Question on benchmarks on derby.
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I have been looking for benchmarks used on Derby.
We have tried TPC-W on Derby 10.2.2(server mode) and was not a viable teste.
This test have many IN  statements with multilevel querys and max rows
statements. The optimizer doesn't make the best choices, there are
many table scans over indexed columns.  And have some memory leak. So
isn't good for this version.
We have also tried PolePosition benchmark. Better results but too simple test.

I wonder what benchmarks have been in use by the Derby team. TPC-B?
And were can i find the source of those tests.
To test new features on code what are the recommended benchmarks? And
for a generic application?

Thanks.
PJ