[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-java
Subject:    Re: performance measurements via profileSql=true
From:       Mark Matthews <mark () mysql ! com>
Date:       2003-04-17 18:39:36
[Download RAW message or body]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Andrew Houghton wrote:
| Mark (and anyone) --
|
| In your talk at the conference you said, I think, that using the
| profileSql property on a JDBC connection URL would give information like
| query efficiency (trying to find a good way to say this); specifically
| whether every column and every row was used from a ResultSet.
|
| I've been playing, briefly, with the property but I'm not seeing info
| like this.  I'm getting the query itself, the execution time, and the
| fetch time, but nothing on data use.  Did I misunderstand, or is this
| simply not implemented yet?
| I've been testing using both 3.0.7 and 3.1.0.

It's in the nightly snapshots of 3.1.0, which you can get from
http://mmmysql.sourceforge.net/snapshots/dev/

3.0.x has the older, less verbose version of the profiler, which
probably won't be backported because of the amount of code that would
need to be changed, which is not appropriate for a 'stable' branch.

	-Mark


- --
For technical support contracts, visit https://order.mysql.com/?ref=mmma

~    __  ___     ___ ____  __
~   /  |/  /_ __/ __/ __ \/ /  Mark Matthews <mark@mysql.com>
~  / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
~ /_/  /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
~        <___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+nvTotvXNTca6JD8RAs9pAKC31J9K30HInAlYbmDwi51HhvzImgCfXyCV
a6cYz80DDr8ZBWp49hXi95k=
=1ySG
-----END PGP SIGNATURE-----


-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/java?unsub=mysql-java@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]