Zamknięty

Make Microsoft SQL Run in Less than 1 Second

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

Umiejętności: Microsoft SQL Serwer

Zobacz więcej: run sql file, run sql file vbnet, run sql dumps linux, run sql perl, check pop3 run sql, sql microsoft project query, vb6 run sql job

O pracodawcy:
( 0 ocen ) Canada

Numer ID Projektu: #12148807

22 freelancerów złożyło ofertę na średnią kwotę w wysokości $60 do tego projektu.

mpalgeo

Hi I have been working with MSSQL for over 17 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have de Więcej

$100 USD w ciągu 5 dni
(47 Ocen)
5.7
youthpassion

I am a Microsoft certified solutions developer having 10 years experience of software industry in developing web, mobile and desktop applications. I have great expertise in VB, C#, C++, MVC, Asp.Net, SQL Server, JQuery Więcej

$50 USD w ciągu 2 dni
(1 Ocena)
4.8
phiona06

Hi! I'm senior lecturer on databases with 10+ years experirnce in MS SQL Server. As I see in this query need to change every IN statement to JOIN equivalent. And then I need your db with real data. May be need to add Więcej

$50 USD w ciągu 2 dni
(7 Ocen)
3.6
andreyryazanov

Hello! Your SQL statements needs to be redesigned from scratch. I will be able to make it efficient if you let me know about your tables structure and the purpose of the query.

$100 USD w ciągu 1 dnia
(1 Ocena)
3.2
fanninson45

SHOWCASE An experienced Microsoft Certified Professional with Database Programming and Administration skills across both MS SQL and Business Intelligence Development. Having the ability to take the technical lead in p Więcej

$100 USD w ciągu 3 dni
(5 Ocen)
3.3
ajoaosilva

Hi I have over 20 years of experience with SQL, Microsoft SQL Server (since version 6.5 in 1996) and Microsoft Access (since version 2.0 in 1993) so, these database systems don't have many secrets to me. Also, i'm u Więcej

$50 USD w ciągu 3 dni
(6 Ocen)
3.0
ksinghrajeev

Please provide the data and DB create script for ipm_asset, asset_filetype_lookup, ipmrank, ipm_group, ipm_group_user tables. I will try to work.

$55 USD w ciągu 2 dni
(1 Ocena)
1.9
riveralf

Hello, I have more than 16 years of experience as SQL Server DBA, I am focusing on bottleneck detection and query optimization. I can help you with the issue that you are reporting on this project. Reagrds, L Więcej

$50 USD w ciągu 2 dni
(4 Ocen)
1.9
vw7590795vw

Please check below query and let me know. select  X.*  from  (  select  ipmrank.RANK rating, a.asset_id  From dbo.ipm_asset AS a (NOLOCK) INNER JOIN dbo.IPM_asset AS b (NOLOCK) ON b.asset_id = a.asset_id INNE Więcej

$50 USD w ciągu 0 dni
(2 Ocen)
1.8
khannouman

hi.Yes i can do this for you . I will optimize your query and it will run on 1 sec. Kindly reply me and create milestone . Hope to hear you back.Thanks

$55 USD w ciągu 2 dni
(0 Ocen)
0.0
Agiletechstudio

Sir I have 4 year+ experience in .net Development. I have work on Different Desktop and web applications in my Carrier. I read your basic requirement and want to some detail information about data. I will give you com Więcej

$50 USD w ciągu 2 dni
(0 Ocen)
0.0
ebonnevi

I' dedicated to my work! i'm always avalaible to help other person or companies. I'm sure we can collaborate on short or long terms.

$55 USD w ciągu 10 dni
(0 Ocen)
0.0
alexarroyo

try this: select a.asset_id into #asset_id_a from asset_filetype_lookup a where a.convertertype in (1,2)) SELECT asset_id into #ipm_asset_id FROM IPM_asset a inner join #asset_id_a b on a.asset_id = b.a Więcej

$50 USD w ciągu 1 dnia
(0 Ocen)
0.0
TayNelson

I can do this, but I would need a database schema and at least some data (if not all)

$55 USD w ciągu 1 dnia
(0 Ocen)
0.0
seniorprgorammer

Hi, I need to have SQL Server database as well in order to optimize this query. Please provide me Thanks, Hafiz

$55 USD w ciągu 10 dni
(1 Ocena)
0.0
projectforsql

4 years of IT experience in Microsoft SQL server Production DBA and Dara warehousing Admin activities. This includes SQL server 2000/2005/2008/2008 R2 and 2012 hands on experience in Production Support, maintenance, mo Więcej

$50 USD w ciągu 10 dni
(0 Ocen)
0.0
romei

Hello, I am a professional programmer from Poland. I consider myself to be an SQL expert. Most likely the query is running slow because of the nested "IN" operators. Would it be possible to get a test version of the da Więcej

$50 USD w ciągu 10 dni
(0 Ocen)
0.0
Maq2

A proposal has not yet been provided

$61 USD w ciągu 5 dni
(0 Ocen)
0.0
serverhint

Hi, I am currently working for a webhosting company , I have good knowledge in Windows and Linux web Technologies, as well as in Server Technologies, I have good experience in Virtualization in VMWare, Xen, KVM, H Więcej

$55 USD w ciągu 2 dni
(0 Ocen)
0.0
$55 USD w ciągu 1 dnia
(0 Ocen)
0.0