You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by Charles Anthony <ch...@hpdsoftware.com> on 2004/03/03 09:35:11 UTC
RE: Logging SQL for automatic index generation or performance Ana
lysation ?
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: sschloesser@intermediate.de [mailto:sschloesser@intermediate.de]
> Sent: 03 March 2004 08:32
> To: ojb-user@db.apache.org
> 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: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
___________________________________________________________
HPD Software Ltd. - Helping Business Finance Business
Email terms and conditions: www.hpdsoftware.com/disclaimer
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Sorry error to forward message !
Posted by Reda Benzair <re...@smartjog.com>.
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: sschloesser@intermediate.de [mailto:sschloesser@intermediate.de]
>>> Sent: 03 March 2004 08:32
>>> To: ojb-user@db.apache.org
>>> 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: ojb-user-unsubscribe@db.apache.org
>>> For additional commands, e-mail: ojb-user-help@db.apache.org
>>>
>>>
>>>
>>
>>
>>
>> ___________________________________________________________
>> HPD Software Ltd. - Helping Business Finance Business
>> Email terms and conditions: www.hpdsoftware.com/disclaimer
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
>> For additional commands, e-mail: ojb-user-help@db.apache.org
>>
>>
>>
>
>
--
*Reda BENZAIR**
*Software Analyst
***
*Phone: +33 (0)1 4996 6324
Fax: +33 (0)1 4996 6405
Mobile: +33 (0)6 6240 6192
reda.benzair@smartjog.com <ma...@smartjog.com>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
un outil interessant pour la supervission des statment JDBC
Posted by Reda Benzair <re...@smartjog.com>.
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: sschloesser@intermediate.de [mailto:sschloesser@intermediate.de]
>>Sent: 03 March 2004 08:32
>>To: ojb-user@db.apache.org
>>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: ojb-user-unsubscribe@db.apache.org
>>For additional commands, e-mail: ojb-user-help@db.apache.org
>>
>>
>>
>>
>
>
>___________________________________________________________
>HPD Software Ltd. - Helping Business Finance Business
>Email terms and conditions: www.hpdsoftware.com/disclaimer
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
>For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
>
--
*Reda BENZAIR**
*Software Analyst
***
*Phone: +33 (0)1 4996 6324
Fax: +33 (0)1 4996 6405
Mobile: +33 (0)6 6240 6192
reda.benzair@smartjog.com <ma...@smartjog.com>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: Logging SQL for automatic index generation or performance Analysation
?
Posted by Stefan Schlösser <ss...@intermediate.de>.
Hi Charles,
thanks for this, this tool is great - I already got 1 half of what I
need. Took me some 30 min. to integrate it in our application !
Thanks.
Stefan
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: sschloesser@intermediate.de [mailto:sschloesser@intermediate.de]
>>Sent: 03 March 2004 08:32
>>To: ojb-user@db.apache.org
>>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 ?
>>
>
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
>>For additional commands, e-mail: ojb-user-help@db.apache.org
>>
>>
>
>
>
> ___________________________________________________________
> HPD Software Ltd. - Helping Business Finance Business
> Email terms and conditions: www.hpdsoftware.com/disclaimer
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org