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

* Your Email Address
* Spam protection	Enter the letters below: .___.___. .. .. [__ [__ \ /\ /\| [___[___ \/ \/ \|___
Comment	> Mysql does not uses indexes for bitwise operations. So it performs a > full table scan. I was aware of this while I was writing the native > driver. But I let this problem as it is still much better than the DT > driver and had no time to solve even this. This part is still on my > TODO... > > > > Another table scan was introduced in in revision 1.35 of mrubinsk by > adding the DISTINCT statement in the SQL query. And this is the > real performance killer for MySQL. As it must scan the joined table > - it means that must allocate a new temporary table with all joined > data, using limit or not. Brrr.... > > > > So we must reorganize data and query to avoid this two table scans.
Attachment
Watch this ticket