Cerrado

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

Habilidades: Servidor de Microsoft SQL

Ver más: run sql file, resume sql microsoft access conversion, run sql file vbnet, run sql dumps linux, run sql script automatically phpmyadmin, run sql perl, check pop3 run sql, sql microsoft project query, vb6 run sql job, run sql server 2005 script, coding java applet can run ie7 microsoft jvm, console application run sql 2005 script, microsoft access multi select listbox, run sql backup job vb6, run sql commands perl script simple

Información del empleador:
( 0 comentarios ) Canada

ID de proyecto: #12148807

22 los freelancers están ofertando un promedio de $60 para este trabajo.

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 Más

$100 USD en 5 días
(47 comentarios)
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 Más

$50 USD en 2 días
(1 comentario)
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 Más

$50 USD en 2 días
(7 comentarios)
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 en 1 día
(1 comentario)
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 Más

$100 USD en 3 días
(5 comentarios)
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 Más

$50 USD en 3 días
(6 comentarios)
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 en 2 días
(1 comentario)
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 Más

$50 USD en 2 días
(4 comentarios)
1.9
vw7590795vw

Please check below query and let me know. select  X.*  from  (  select  [url removed, login to view] 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 Más

$50 USD en 0 días
(2 comentarios)
1.8
khannouman

[url removed, login to view] 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 [url removed, login to view]

$55 USD en 2 días
(0 comentarios)
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 Más

$50 USD en 2 días
(0 comentarios)
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 en 10 días
(0 comentarios)
0.0
alexarroyo

try this: select a.asset_id into #asset_id_a from asset_filetype_lookup a where [url removed, login to view] 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 Más

$50 USD en 1 día
(0 comentarios)
0.0
TayNelson

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

$55 USD en 1 día
(0 comentarios)
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 en 10 días
(1 comentario)
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 Más

$50 USD en 10 días
(0 comentarios)
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 Más

$50 USD en 10 días
(0 comentarios)
0.0
Maq2

A proposal has not yet been provided

$61 USD en 5 días
(0 comentarios)
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 Más

$55 USD en 2 días
(0 comentarios)
0.0
$55 USD en 1 día
(0 comentarios)
0.0