db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Matrigali <mikem_...@sbcglobal.net>
Subject Re: Derby performance and data volume
Date Wed, 22 Sep 2004 16:46:09 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I have not used any tools specific to derby.  I have used a generic java
profiler to find cpu and memory leak issues.  Mostly I have used
optimizit, which is not an open source tool.  I know others have used
the profiler tools that come with the jdk installation.  I don't know if
there are any open source java profile analysis tools out there, if
anyone knows of an open source java profile/memory analysis tools please
post the info to the list.

About the only tool provided by derby is the ability to print out the
query plan produced by the optimizer.  From this one can try to tell
whether the proper index is being used, but this is pretty complicated
and there are not tools to make it easier to read/understand.  There is
some documentation in the standard doc set about what the query plan
output means.

This is another area where there is more needed to be done, if anyone in
the community is interested.  A tool that read the raw output of the
query plan and then presented visually easier to the user would be
useful. Even more interesting would be a tool that could suggest useful
indexes to be created, given the ddl of the database and the queries
that are to be run against the database.

David Zonsheine wrote:
| Mike,
| Thank you very much for the detailed answer.
| It helps me a lot in choosing Derby.
| One more important question:
| Are there any execution tools for Cloudscape / Derby?
| Tools to analyze execution path and more?
| Thanks again,
| David
|
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFBUaw/EpeslyHqPs0RAjXcAJ458opiJIs/ippmO1uWDextXzORZACfZQxT
ZUoNpn75fn9HblcjfvAz8z8=
=nlnw
-----END PGP SIGNATURE-----

Mime
View raw message