You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Michael Campbell <mi...@gmail.com> on 2005/09/26 05:04:01 UTC
Caching; how do I know it's working?
Is a cache hit/miss logged? I've run a test of running the same
select in a loop, and my ibatis log4j output shows n copies of the
prepared statement, result set operations happening.
Is the logging supposed to distinguish between a cache hit and a real db call?
--
I tend to view "truly flexible" by another term: "Make everything
equally hard". -- DHH
Re: Caching; how do I know it's working?
Posted by Larry Meadors <la...@gmail.com>.
Nope.
On 9/25/05, Michael Campbell <mi...@gmail.com> wrote:
> Is a cache hit/miss logged? I've run a test of running the same
> select in a loop, and my ibatis log4j output shows n copies of the
> prepared statement, result set operations happening.
>
> Is the logging supposed to distinguish between a cache hit and a real db call?
>
> --
> I tend to view "truly flexible" by another term: "Make everything
> equally hard". -- DHH
>
Re: Caching; how do I know it's working?
Posted by Ron Grabowski <ro...@yahoo.com>.
There was an issue for this in Jira while ago. I think its still open:
http://issues.apache.org/jira/browse/IBATIS-151
Unfortunetly the links on irongrid.com no longer exists (I wasn't able
to retrieve them from archive.org either). Their cache monitoring
program showed each sql statement, its execution time, and its cache
hit percentage.
--- Michael Campbell <mi...@gmail.com> wrote:
> I would, but I'm a metrics freak.
>
>
> On 9/26/05, Ron Grabowski <ro...@yahoo.com> wrote:
> > IBatisNet has a GetDataCacheStats method on the main sqlMapper
> object
> > that outputs a simple summary of statements and their cache hit
> ratio:
> >
> > User.GetMany: 51%
> > User.GetOneById: 20%
> > User.GetManyById: No cache.
> > ...
> >
> > Maybe this is a feature that the Java people would find useful.
> >
> > --- Michael Campbell <mi...@gmail.com> wrote:
> >
> > > Is a cache hit/miss logged? I've run a test of running the same
> > > select in a loop, and my ibatis log4j output shows n copies of
> the
> > > prepared statement, result set operations happening.
> > >
> > > Is the logging supposed to distinguish between a cache hit and a
> real
> > > db call?
> > >
> > > --
> > > I tend to view "truly flexible" by another term: "Make everything
> > > equally hard". -- DHH
> > >
> >
> >
>
>
> --
> I tend to view "truly flexible" by another term: "Make everything
> equally hard". -- DHH
>
Re: Caching; how do I know it's working?
Posted by Michael Campbell <mi...@gmail.com>.
I would, but I'm a metrics freak.
On 9/26/05, Ron Grabowski <ro...@yahoo.com> wrote:
> IBatisNet has a GetDataCacheStats method on the main sqlMapper object
> that outputs a simple summary of statements and their cache hit ratio:
>
> User.GetMany: 51%
> User.GetOneById: 20%
> User.GetManyById: No cache.
> ...
>
> Maybe this is a feature that the Java people would find useful.
>
> --- Michael Campbell <mi...@gmail.com> wrote:
>
> > Is a cache hit/miss logged? I've run a test of running the same
> > select in a loop, and my ibatis log4j output shows n copies of the
> > prepared statement, result set operations happening.
> >
> > Is the logging supposed to distinguish between a cache hit and a real
> > db call?
> >
> > --
> > I tend to view "truly flexible" by another term: "Make everything
> > equally hard". -- DHH
> >
>
>
--
I tend to view "truly flexible" by another term: "Make everything
equally hard". -- DHH
Re: Caching; how do I know it's working?
Posted by Ron Grabowski <ro...@yahoo.com>.
IBatisNet has a GetDataCacheStats method on the main sqlMapper object
that outputs a simple summary of statements and their cache hit ratio:
User.GetMany: 51%
User.GetOneById: 20%
User.GetManyById: No cache.
...
Maybe this is a feature that the Java people would find useful.
--- Michael Campbell <mi...@gmail.com> wrote:
> Is a cache hit/miss logged? I've run a test of running the same
> select in a loop, and my ibatis log4j output shows n copies of the
> prepared statement, result set operations happening.
>
> Is the logging supposed to distinguish between a cache hit and a real
> db call?
>
> --
> I tend to view "truly flexible" by another term: "Make everything
> equally hard". -- DHH
>