Re: [Sqlgrey-users] Performance: strict versus loose expiration time

[Lionel B. <lio...@bo...>]

Michael Storz wrote the following on 28.02.2007 18:27 :
> On Wed, 28 Feb 2007, Lionel Bouton wrote:
>
>   
>> I don't believe this is a good example, I believe you get a benefit from
>> the query cache only if the whole query (not only the prepared
>> statement) is exactly the same. So in the example above you'll need to
>> have the same timestamp AND the same sender_name, sender_domain, src.
>> Losing the timestamp don't bring much benefits, because the rate at
>> which the from_awl is updated (entries added, updated or deleted)
>> probably is far higher than the rate at which the sender+src comes back.
>>
>>     
>
> Lionel,
>
> I am not talking about normal operation. What I am concerned about are
> spam attacks, where you have to react as fast as possible.
>
>   

I see your point. Smoothing out load spikes is clearly a good goal. I'll 
eagerly await your bench results :-)

Lionel.