Getting 502 on join eloquent laravel



  • I need to get distinct value using inner join. Here is query

        SELECT  distinct(ad_camp_sid.cid)
            from  ad_camp_sid
            inner join  ad_dsp_sites  ON ad_dsp_sites.site_id = ad_camp_sid.sid
            where  ad_dsp_sites.exchange = 4 
    

    table has records count as below: ad_camp_sid = 25602 ad_dsp_sites = 371173

    Here ad_camp_sid.cid has thousands of records. I have added index on columns as well. Still its not responding. Can i user alternative or any solution for same.

    Please suggest me.



  • Add these composite indexes:

    ad_camp_sid:  INDEX(sid,  cid)
    ad_dsp_sites:  INDEX(exchange, site_id)
    

    When adding a composite index, DROP index(es) with the same leading columns. That is, when you have both INDEX(a) and INDEX(a,b), toss the former.




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2