JDBC SQL Profiler 0.3

JDBC SQL Profiler is a quickly hacked tool to do statistics on SELECT queries in order to know where it is most efficient to create i

Developer:	Serge Huber more software by author →
Price:	0.00
License:	The Apache License
File size:	0K
Language:
OS:
Rating:	0 /5 (0 votes)
Your vote:
enlarge screenshot

JDBC SQL Profiler is a quickly hacked tool to do statistics on SELECT queries in order to know where it is most efficient to create indexes.

This small tool, released under an Apache-based license connects to the P6Spy JDBC logger and displays in real time the queries going to the database. It uses an integrated SQL parser to build statistics on the most accessed tables and columns and can generate SQL index creation files.

Other information is also gathered and displayed, such as the request time for a single request, for a class of request, and for all the requests. Sorting may be done on these views to detect database problems efficiently.

This tool can be very useful when you have a big volume of queries that you need to analyze not one by one (meaning that the specific time isn't that much of interest), but rather when you want to know what "group" of queries is taking a lot of time, such as queries on the same tables and columns but with different query values. The integrated SQL parser (built with ANTLR) is used to analyze the incoming SELECT queries.

The Swing GUI was based on Apache's Log4J Chainsaw, but all the bugs are mine. Also contributors are welcome to test, make new suggestions, give their opinion and submit patches.
tags

all the when you and columns tables and integrated sql sql parser select queries

Download JDBC SQL Profiler 0.3

http://prdownloads.sourceforge.net/sqlprofiler/sqlprofiler-0.3-src.zip?use_mirror=belnet

http://prdownloads.sourceforge.net/sqlprofiler/sqlprofiler-0.3-src.zip?use_mirror=voxel

http://prdownloads.sourceforge.net/sqlprofiler/sqlprofiler-0.3-src.zip?use_mirror=kent

Authors software

Similar software

JDBC SQL Profiler 0.3 (by Serge Huber)
JDBC SQL Profiler is a quickly hacked tool to do statistics on SELECT queries in order to know where it is most efficient to create i

Basset::DB::Table 1.03 (by Jim Thomason)
Basset::DB::Table is used to define database tables, ways to load that data into memory and build queries based upon the table inform

Practical Query Analyzer 1.6 (by Tom Copeland)
Practical Query Analyzer produces HTML reports on the most frequent queries, slowest queries, queries by type (select/insert/update/d

StelsXML 1.0 (by J-Stels Software)
StelsXML is a JDBC type 4 driver that allows to perform SQL queries and other JDBC operations on XML files.

With StelsXML JDBC dri

PHP mySQL Database Wrapper Class 1.0.7 (by Stefan Gabos)
PHP mySQL Database Wrapper Class provides a set of methods for interacting with a MySQL database easily and securely

dnsproxy 1.15 (by Armin Wolfermann)
dnsproxy daemon is a proxy for DNS queries

MySQA 1.0.2 (by Franco Biaggi)
MySQA program is a useful program to analyze log files created by MySQL slow queries or queries that don't use indexes.

About MySQ

mod_libpq 0.1a3 (by Andrew Smith)
mod_libpq is an Apache 1.3 Web server module which maintains persistent connections to one or more PostgreSQL databases, eliminating

Querylog 0.1 (by Marcel Meulemans)
Querylog project is a console tool for performing SQL queries on a (log) file.

Lines from one or more text files or stdin are matc

mod_whois 0.1 (by Alexander Mayrhofer)
mod_whois module maps WHOIS queries into standard HTTP requests.

After the "translation", the request can be processed by the usua

Other software in this category

phpMyAdmin 2.9.1.1 (by phpMyAdmin Devel Team)
phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the WWW.

Currently it can create and drop

TUTOS 1.3.20060914 (by Gero Kohnert)
TUTOS prpject is a tool to manage the the organizational needs of small groups, teams, departments ...

Here are some key features

Information Resource Manager 1.5.7 (by Yann Ramin)

Netjuke 1.0 RC2 (by Blake Watters)
Artekopia Netjuke is a cross-platform Web-based audio streaming jukebox powered by PHP 4 and an increasing choice of databases.

MP

TYPO3 4.0.3 RC1 (by Kasper Sk?rh?j)
TYPO3 is a free Open Source content management system for enterprise purposes on the web and in intranets.

TYPO3 offers full flexi