[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         | Duck <duck at obala.net>
  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              | 1
  Owners             | Horde Developers, Chuck Hagenbuch
+New Attachment     | sql.diff
------------------------------------------------------------------------------


Duck <duck at obala.net> (2008-10-06 13:35) wrote:

In general I am counter to a solution on the PHP part. As you still  
need to load the data on the client site (probably from a remote  
server) and process it.

What about GROUP BY?
DISTINCT is normaly used to remove duplicates. GROUP BY to aggregate  
operators to each group. In our occasion DISTINCT and GROUP BY  
generates the same query plan. Probably will be faster to use GROUP BY  
for listings as better results in joins.
Even for counting we can use GROUP BY where we need to return just the  
number of rows affected instead of looping it into the countShares().

Look at the patch. And try it on your data.