Re: Cacheing rowless queries?

2005-12-08 Thread Michael Campbell
Vinny <[EMAIL PROTECTED]> writes: > On 11/10/05, Paul Benedict <[EMAIL PROTECTED]> wrote: > > ...While you're at it, I don't think caching works unless you pass > > in parameters; I have MANY parameterless queries and I haven't > > been able to see them get cached yet (stay tuned). > > > Is thi

Re: Cacheing rowless queries?

2005-12-07 Thread Vinny
On 11/10/05, Paul Benedict <[EMAIL PROTECTED]> wrote: ...While you're at it, I don't think caching > works unless you pass in parameters; I have MANY parameterless queries and I > haven't been able to > see them get cached yet (stay tuned). Is this true? Parameterless queries like SELECT * FROM

RE: Cacheing rowless queries?

2005-11-10 Thread Paul Benedict
u meant by non-result > vs. empty result? > > -Original Message- > From: Paul Benedict [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 10, 2005 6:48 PM > To: user-java@ibatis.apache.org > Subject: Re: Cacheing rowless queries? > > Niels, > > That&#

RE: Cacheing rowless queries?

2005-11-10 Thread Voorhoeve, Niels {PBG}
empty result? -Original Message- From: Paul Benedict [mailto:[EMAIL PROTECTED] Sent: Thursday, November 10, 2005 6:48 PM To: user-java@ibatis.apache.org Subject: Re: Cacheing rowless queries? Niels, That's like a really awesome idea. What kind of marker do you propose to determine a

Re: Cacheing rowless queries?

2005-11-10 Thread Paul Benedict
Niels, That's like a really awesome idea. What kind of marker do you propose to determine a non-result from an empty result? I would find this super valuable. While you're at it, I don't think caching works unless you pass in parameters; I have MANY parameterless queries and I haven't been able

Cacheing rowless queries?

2005-11-10 Thread Voorhoeve, Niels {PBG}
Hi, How difficult / desirable would it be to code a feature in the cacheing mechanism to keep track of queries that do not return any objects? In our case, we end up hitting the database many times for queries that don't return objects. It would be nice to check a cache of non-results to avoid t