optimice my consult

Discussion in 'MySQL' started by wsoulrc, Aug 24, 2011.

0
  1. #1
    my site is low, but the cosult

    table plusone (400 tablas):
    - id
    - iduser
    - creditos
    - cdia
    - cdiausados

    table plusone_stats (13000):
    - id
    - iduser
    - idplus

    SELECT * FROM plusone T WHERE NOT EXISTS ( SELECT NULL FROM plusone_stats N WHERE T.id=N.idplus AND N.iduser='$du['id']') AND T.iduser<>'$du['id']' AND T.creditos>0  AND (T.cdiausados>0 AND T.cdia>0 OR T.cdia=0)
    PHP:
     
    wsoulrc, Aug 24, 2011 IP