[dev] [horde] Simple Solution to 'Database performance problem with

[Ben Chavet]

Quoting Chuck Hagenbuch <chuck at horde.org>:

> Quoting Chuck Hagenbuch <chuck at horde.org>:
>
>>> Thanks to Ioannis Koutsileos, the simple solution I proposed was
>>> implemented and has been working great for us for the past week.
>>> Hope this helps others as well.
>>
>> I've committed this change to HEAD as it tested okay locally for me.
>> I'm not sure I can subjectively tell the difference on my main
>> install, but on a laptop install that used to be pretty pokey things
>> definitely feel zippier.
>>
>> Please, anyone with a HEAD checkout, test this and let us know how
>> it does and if you find any problems with it. If it checks out we'll
>> get it into a stable release sooner rather than later.
>
> As a followup, this morning I realized that this had broken things -
> the most obvious symptom was that you no longer saw shares that you
> didn't own. The solution is that OR results need to be accumulated
> instead of returning the first one - these are sets (union), not
> boolean or.

I've been using this in production for a while now, and it seems to be  
working fine.  I can't really tell if this helped speed things up any,  
though.

--Ben

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: PGP Digital Signature
Url : http://lists.horde.org/archives/dev/attachments/20060923/f6188856/attachment.bin