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

* Your Email Address
* Spam protection	Enter the letters below: .__ __..___\ /.___. [__)(__ [__ >< _/ \| .__)[___/ \./__.
Comment	> 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.
Attachment
Watch this ticket