Re: Jackrabbit SQL Queries

[Nicolas Modrzyk <ni...@macnica.com>]

Hi,

> Is there any way to make jackrabbit log executed queries,their  
> execution
> times and result size?

AFAIK, this is not done in the default jackrabbit code, but it would  
be really easy to:
- checkout the code
- put a simple aspect around the class/methods executing the SQL queries
- compile and change the jar file

Result size, from my experience on C-JDBC was a killer, especially as  
some data and metadata are streamed on demand when you actually  
access the result.
So it may not be a valuable indicator.

Regards,

Niko,

Re: Jackrabbit SQL Queries

[Skripnikov <ma...@voliacable.com>]

Thanks, checked it out, add try{}finally{} to DatabasePersistenceManager and
DatabaseFileSystem, thanks to jackrabbit team  - the code is much better
than 1.1 - only two places in 1.2 instead of multiple ones in 1.1
 

Nicolas Modrzyk-2 wrote:
> 
> Hi,
> 
>> Is there any way to make jackrabbit log executed queries,their  
>> execution
>> times and result size?
> 
> AFAIK, this is not done in the default jackrabbit code, but it would  
> be really easy to:
> - checkout the code
> - put a simple aspect around the class/methods executing the SQL queries
> - compile and change the jar file
> 
> Result size, from my experience on C-JDBC was a killer, especially as  
> some data and metadata are streamed on demand when you actually  
> access the result.
> So it may not be a valuable indicator.
> 
> Regards,
> 
> Niko,
> 
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/Jackrabbit-SQL-Queries-tf3150952.html#a8740321
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.