On Friday, July 28, 2017 at 11:37:10 AM UTC-7, Aryk Grosz wrote: > > Hi Jeremy, it seems like it's working, but why is that it essentially > plugins in the associations twice if you opt in > for dataset_associations_join? > > What if I just want the joins but not the subselect in the where clause? >
My recollection is you need both for correct behavior (the subselect does the correct filtering). The joins added by dataset_associations_join outside the subselect are if you want to also filter/order by the joined tables . I'll certainly consider optimization patches, as long as they are accompanied by an analysis showing the same behavior results in all cases. Thanks, Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
