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

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