Thanks again for the detailed answer. David Zonsheine -----Original Message----- From: Mike Matrigali [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 6:46 PM To: Derby Discussion Subject: Re: Derby performance and data volume
-----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----- -------------------------------------------------------------------------------------------------------------------------------------------------------------- This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the originator of the message. Scanning of this message is performed by SurfControl E-mail Filter software in conjunction with virus detection software.
