Reda Benzair wrote:
suite à une discution dans OJB forum
il y un autil tres interessant Open Source pour la suppervission au
niveau du JDBC
interessant de voir ça si en peut l'integer chez nous
http://www.irongrid.com/catalog/product_info.php?products_id=32
Charles Anthony wrote:
Hi,
I'm not sure if you are aware, but there is already a tool to do
this, based
on the p6spy jdbc driver.
It's available under the Apache license too.
I believe the only thing it doesn't do is the analysis of the data to
suggest indices.
http://www.irongrid.com/catalog/product_info.php?products_id=32
I've only glanced at the tool, not used it.
Even if that tool is not what you want, it's probably better to
extend the
p6spy driver to do what you want - as it would be applicable across all
environments that use jdbc
Cheers,
Charles.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 03 March 2004 08:32
To: [EMAIL PROTECTED]
Subject: Logging SQL for automatic index generation or performance
Analysation ?
Hi,
I would like to know where the best place would be to hook into ojb
a class
which logs all sql statements sent to the DB.
My idea is to analyze the from and where clause and log into a database
table the actual statements used in a live system. I then would like to
write a tool which analyzes this table and suggests the "best"
indices to
create on the database.
To make sure I really catch all statements I would like to directly
hook
into ojb. Also, this could then easily be re-used.
We thought about a trace but the amount of data just seems to big.
Any ideas / suggestions ?
Thanks,
Stefan Schlösser
--------------------------------------------------------------
-----------
I N T E R M E D I A T E GmbH & Co. KG
eSolutions & Integration
Durmersheimer Straße 55 t +49 (0)721.98644-50
76185 Karlsruhe f +49 (0)721.98644-99
http://www.intermediate.de
P.S. Als Beratungs- und Systemhaus optimiert Intermediate die
Geschäftsprozesse mittelständischer Unternehmen in Vertrieb,
Marketing und Kundenservice.
Tätigkeitsschwerpunkte sind Angebots- und Produkt-Konfiguration
sowie Enterprise Content-Management-Systeme.
Unsere besondere Stärke liegt in der Integration bestehender
Systeme, insbesondere von ERP-Systemen wie SAP R/3, BRAIN AS,
MAS90 etc.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
___________________________________________________________
HPD Software Ltd. - Helping Business Finance Business
Email terms and conditions: www.hpdsoftware.com/disclaimer
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
*Reda BENZAIR**
*Software Analyst
***
*Phone: +33 (0)1 4996 6324
Fax: +33 (0)1 4996 6405
Mobile: +33 (0)6 6240 6192
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]