[SQL ] 精簡指令~~

[tas72732002 (蔥頭)]

   因為我有好多支SQL要一同執行 但這樣造成效能很慢  想請問一下


  $query1="SELECT count(uid) FROM `user_profile` WHERE valid_email='0' and create_time LIKE '{$trans_Date}%'";

  $query2="SELECT count(uid) FROM `user_profile` WHERE state='INIT' and create_time LIKE '{$trans_Date}%'";

  $query3="SELECT pageview,visit FROM prs_paper WHERE paper_t LIKE '{$trans_Date}%'";

  $query4="SELECT count(uid) FROM `prs_member` WHERE create_time < '{$trans_Date}'";

  1與2和3與4 可以並再一起變成兩個SQL嗎

--
感謝大家的推文

--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 122.116.92.103
→ AndCycle:效能很慢先用explain看過他怎麼跑的