用asp.net做了个招聘的网站,本来以为数据库没多大就用了access我错了,我是真的错了!稍微发杂点的语句页面执行时间就达到了2秒发一条sql语句大家看下怎么优化下select top 9 IIf(len(E_companyname)>=21,left([E_companyname],20)&'..',E_companyname) as E_company,E_companyname,E_id from E_user,Job_info where Format([J_enddate],'yyyy-mm-dd')>Format(now,'yyyy-mm-dd') and J_pass='True' and cint(J_eid)=E_id and E_pass='True' and E_id not in(select top 9 E_id from E_user,Job_info where Format([J_enddate],'yyyy-mm-dd')>Format(now,'yyyy-mm-dd') and J_pass='True' and cint(J_eid)=E_id and E_pass='True' and J_classtype='普通招聘' and (J_adddate IN (SELECT MAX(J_adddate) AS Expr1 FROM job_info where J_classtype='普通招聘' GROUP BY j_eid)) order by J_adddate desc) and J_classtype='普通招聘' and (J_adddate IN (SELECT MAX(J_adddate) AS Expr1 FROM job_info where J_classtype='普通招聘' GROUP BY j_eid))
更换数据库,如果这是必须的话