关闭

Make Microsoft SQL Run in Less than 1 Second

该项目收到23 来自天才威客的竞标,平均竞标价格为$59 USD

为像这样的项目获取免费报价
雇主工作
项目预算
$50 USD
全部竞标
23
项目描述

The query takes about 7 seconds. I need it to run in less than 1 second.

--------------------------------------

select a.* from( select [url removed, login to view] rating,a.asset_id From ipm_asset a INNER JOIN CONTAINSTABLE(ipm_asset,*,'ISABOUT("NAME" NEAR "*jpg*" weight (.4),"TAGS" NEAR "*jpg*" weight (.3),"SERVICES" NEAR "*jpg*" weight (.2),"MEDIA" NEAR "*jpg*" weight (.1),"ILLUST" NEAR "*jpg*" weight (.6),"FILENAME" NEAR "*jpg*" weight (.4),FORMSOF (inflectional,"jpg") weight (.6) ,FORMSOF (thesaurus,"jpg") weight (.4) )') as ipmrank on a.asset_id = ipmrank.[KEY] where 1=1 and a.asset_id in ( SELECT asset_id FROM IPM_asset a WHERE [url removed, login to view] = 'Y' and asset_id in (select a.asset_id from asset_filetype_lookup a where [url removed, login to view] in (1,2 )) ) and [url removed, login to view] <> 84 and [url removed, login to view] <> 85 and [url removed, login to view] <> 48 and [url removed, login to view] <> 64 and [url removed, login to view] = 'Y' /*end*/ ) a join (select asset_id from ipm_asset_security Where ((security_id in (select [url removed, login to view] from ipm_group a, ipm_group_user b where [url removed, login to view] = 'Y' and [url removed, login to view] = [url removed, login to view] and [url removed, login to view] = '1') and type = 'G')) or (security_id = '1' and type = 'U') union select asset_id from ipm_asset a where a.securitylevel_id >= '0' ) d on a.asset_id = d.asset_id

在寻找赚取金钱的机会?

  • 设定您的预算和时间框架
  • 大致描述您的建议方案
  • 为您的工作领取工资

雇用同样在该项目上竞标的威客

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online