[Tickets #7363] Re: Avoid bitwise operations in the SQL Share driver

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/7363
------------------------------------------------------------------------------
  Ticket             | 7363
  Updated By         | adrieder at sbox.tugraz.at
  Summary            | Avoid bitwise operations in the SQL Share driver
  Queue              | Horde Framework Packages
  Version            | FRAMEWORK_3
  Type               | Enhancement
  State              | Accepted
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


adrieder at sbox.tugraz.at (2008-09-21 04:50) wrote:

> Or maybe rewriting the query using subquery and union:
[....]
> Perhaps gaining a better utilization of index in the database queries.

In my tests (I think it should read "LEFT JOIN nag_shares_users"  
instead of "LEFT JOIN kronolith_shares_users") your modified query  
with the subquery was up to 6 times as fast as the original query. The  
database holds about 12,000 shares.